OraFAQ Forum: SQL & PL/SQL » I can't have my SQL prompt after excuting my stored procedure

Home » SQL & PL/SQL » SQL & PL/SQL » I can't have my SQL prompt after excuting my stored procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I can't have my SQL prompt after excuting my stored procedure [message #18448]

Thu, 31 January 2002 06:07

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?

Report message to a moderator

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

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

hi,

is there a infinite loop inside the procedure

put trace ..

cheers
pratap

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 06:26:16 CDT 2024