Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » How to run procedure in Apex object browser (Oracle 10G Apex 3.0)
How to run procedure in Apex object browser [message #301318] Wed, 20 February 2008 00:57 Go to next message
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 #304000 is a reply to message #301318] Mon, 03 March 2008 11:45 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Sure - try this
begin
  dbms_output.put_line('hello apex');
end;


Result:
hello apex

Statement processed.


0.94 seconds
  
Re: How to run procedure in Apex object browser [message #304342 is a reply to message #304000] Tue, 04 March 2008 23:34 Go to previous messageGo to next message
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 #304405 is a reply to message #304342] Wed, 05 March 2008 01:23 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
I don't understand your point - dbms_output.put_line is a packaged procedure.
Re: How to run procedure in Apex object browser [message #304420 is a reply to message #304405] Wed, 05 March 2008 02:11 Go to previous message
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

Previous Topic: Single column multiple row alignment of data within column problem
Next Topic: Text Area - 400 Bad Request Error
Goto Forum:
  


Current Time: Thu Dec 08 04:22:25 CST 2016

Total time taken to generate the page: 0.06774 seconds