Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vijuvelu

    Server: Msg 1203, Level 20, State 1, Line 1

    When I query a view in SQL server, I get this error: Server: Msg 1203, Level 20, State 1, Line 1 Process ID 10 attempting to unlock unowned resource PAG: 10:1:2258. Connection Broken This is the explanation and action I found for this error...
  2. vijuvelu

    Copying BLOBs between databases (ORA-22992)

    I am migrating data from one db to another. I have a link between the two and one of the tables have BLOB datatype for one of their attributes. I need to cursor through this table and then insert the cursor variable values into the other db's table. I get the ORA-22992 error when I run the...
  3. vijuvelu

    Cursors

    Thank you Sem and Jim. What I did was: Create cursor2(pid in number) is select dept_no, dept_name from dept where emp_id = pid; and then opened it passing the 1st cursor value, ie, open cursor2(cursor1.emp_id); It Worked! -Viju. *:->*
  4. vijuvelu

    Cursors

    Can anyone give me a example on how to build a cursor with the attribute of another cursor, for eg: if cursor1 is select emp_id, emp_name from emp; I want to build cursor2 which is select dept_no, dept_name from dept where emp_id = cursor1.emp_id. Thanks!
  5. vijuvelu

    Link to SQL Server

    Has anyone tried to connect to SQL Server through Oracle? I need to load a table in SQL Server (remote server) with the data in a table in Oracle. Thanks.
  6. vijuvelu

    Oracle - SQL Server

    Thank you for your prompt replies. I will try this and reply back. Viju.
  7. vijuvelu

    Oracle - SQL Server

    Thank you Robert! I am sorry my question doesn't give the full picture. I work on Oracle and I need to log on to a remote SQL Server to load a table there with the data in my table. I have the IP address and the username/password for the remote SQL Server. Thanks
  8. vijuvelu

    Oracle - SQL Server

    Can anyone help me in learning how to load a table in SQL Server with the data in a table in Oracle? How do you connect to SQL Server from Oracle?

Part and Inventory Search

Back
Top