| How to run procedure in Apex object browser [message #301318] |
Wed, 20 February 2008 00:57  |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
Whenever I create procedure through Object browser (Apex) after compiling I go to run SQlcommand mode to execute to see the result using exec procedure_name(variable_value); etc. Is there any way to run the procedure in Apex Object browser iself on the SQL command available in Apex.
urs
dr.s.raghu(newbies)
|
|
|
|
|
|
| Re: How to run procedure in Apex object browser [message #304342 is a reply to message #304000] |
Tue, 04 March 2008 23:34  |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
hi,
begin
dbms_output.put_line('hello apex');
end;
The above code is fine for triggering function, statement etc
if you want to run procedures with or without IN variables
you have to use the following in object browser
begin
procedure_name( Variable_name);
end;
dbms_output.put_line is not good for executing procedures in object browser..
Once again thanks a lot
Yours
dr.s.raghunathan
|
|
|
|
|
|
| Re: How to run procedure in Apex object browser [message #304420 is a reply to message #304405] |
Wed, 05 March 2008 02:11 |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
sir,
Iwas using Apex 3.0 wherein, using the object browser i have
created a procedure which will receive one value and based
on the value some processing and insertion in another table
job has been done.
After no error on compiling, I tried to run the procedure
in the sql command window (provided by apex). It was not running. That is the reason I raised the topic.
you had given excellent solution dbms (packaged procedure).
I tried that packed procedure for executing function routine.
It worked fine. Then I tried to run my procedure using the
suggested packaged procedure. That's where It has been failed
and some error has come.
Then I tried simply
begin
procedure_name(variable)
end;
It worked fine.
Before I achieve the object i use to logout and invoke
run sql command mode and logged in. Afterwards on the sql
prompt I tried to run the procedure using exec procedure_name(variable);
after execution and successful, I use to return back to Apex
object browser to continue.
Your suggestion has saved my enormous time. Once again
i reiterate my thanks to you since it was a long pending
issue for me.
Hope I have given my reasons sufficiently.
thanks a lot
yours
dr.s.raghunathan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
