Home » RDBMS Server » Server Administration » Returning to sql script
Returning to sql script [message #370434] Fri, 24 September 1999 09:29 Go to next message
Luis Claudio
Messages: 5
Registered: July 1999
Junior Member
Hi,

I've defined a stored procedure and I called it from a sql script. But, after its execution, it didn't return to the sql script. What can I do to solve this problem?

Thanks for any help in advance.

Luis Claudio
Re: Returning to sql script [message #370435 is a reply to message #370434] Fri, 24 September 1999 09:47 Go to previous messageGo to next message
m a sivan
Messages: 34
Registered: July 1999
Member
can u give the details of the script. if u could please post the part of the code which gives this problem ( the calling line and the end line of the returning procedure)
Re: Returning to sql script [message #370456 is a reply to message #370434] Tue, 28 September 1999 07:41 Go to previous messageGo to next message
Sean Miller
Messages: 12
Registered: December 1998
Junior Member
Is it raising an exception by any chance?

The following should work okay...

.
.
. beginning of sql script
.
.

begin
proc(params);
exception
when others then dbms_output.put_Line(sqlerrm);
end ;
.
.
. rest of sql script
.
.

rather than using "execute proc(params)" which I assume you're doing

sean
Thanx a lot! [message #370459 is a reply to message #370435] Tue, 28 September 1999 09:34 Go to previous message
Luis Claudio
Messages: 5
Registered: July 1999
Junior Member
Ok,

the problem was solved with an exception.

Thanx a lot, folks!

Luis Claudio.
Previous Topic: UTL_FILE Get_line --- NO_DATA_FOUND problem
Next Topic: How to select the latest two rows
Goto Forum:
  


Current Time: Thu Mar 28 16:44:19 CDT 2024