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!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
cursor calling a procedure problem
Thanks for the answer. What is the best way to add the cursor into the stored procedure? Do you just add the cursor after the BEGIN in the stored procedure??? CREATE OR REPLACE PROCEDURE KEVIN .... BEGIN DECLARE v_part_no bp_kev_test.part_no%TYPE; v_class bp_kev_test.class%TYPE...- kmuller
- Post #3
- Forum: Oracle: All versions
-
database link...again....
I think the connect by has to be an actual userid. I jsut created a link between 2 db's, and it was with my own id, identified by my password. Try setting up a dummy id with read only rights on the second db, and see if that works. Hope it helps. K- kmuller
- Post #4
- Forum: Oracle: All versions
-
cursor calling a procedure problem
My questions is reletively simple. I have a cursor that fetches some data. After each fetch it calls a procedure, and passes the selected data to it. Everything runs fine when I run it from SQL PLUS. How do I execute this in the Unix environment? Would I have a scheduling tool kick off the...- kmuller
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Data access on multiple databases
I am having some trouble when I try to connect to multiple databases with Crystal. I am trying to connect to an Informix database, and an Oracle database. I can get the tables pulled into Crystal, but when I try to link them I get error messages. I can link one field fine, but when I try to...- kmuller
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 2 Data Access
