Home » SQL & PL/SQL » SQL & PL/SQL » I can't have my SQL prompt after excuting my stored procedure
I can't have my SQL prompt after excuting my stored procedure [message #18448] Thu, 31 January 2002 06:07 Go to next message
cacael
Messages: 8
Registered: January 2002
Junior Member
I execute a stored procedure . It updates data in my database. It runs correctlt but i can not have the prompt to execute an other request

For instance if my procedure is proc_test. i run
SQL> execute PRoc_test('2002/01/20','2002/01/20') ;

after i can not have the prompt.

What can i' do to solve the problem?
Re: I can't have my SQL prompt after excuting my stored procedure [message #18450 is a reply to message #18448] Thu, 31 January 2002 06:49 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
hi,

is there a infinite loop inside the procedure

put trace ..

cheers
pratap
Previous Topic: performance tuning on paging result set
Next Topic: Good PARTITIONING PRACTICE.. How do i automate partitioning?
Goto Forum:
  


Current Time: Thu Jul 02 11:51:03 CDT 2020