OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » how do i run a procedure in sql apex

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » how do i run a procedure in sql apex

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

how do i run a procedure in sql apex [message #510794]

Tue, 07 June 2011 14:56

macaela
Messages: 17
Registered: January 2011
Location: UK

Junior Member

hi i have a very simple script which i created on oracle
Application Express 3.2.0.00.27

but i can't find a way of running on apex is there no way of running procedures on apex sql if so how can i run whats the sintax i have looked everywhere

CREATE or REPLACE PROCEDURE helloworld as

x varchar2(20);

BEGINx :='hello world';

DBMS_OUTPUT.PUT.LINE_LINE(X);
END;

Report message to a moderator

Re: how do i run a procedure in sql apex [message #510795 is a reply to message #510794]

Tue, 07 June 2011 15:03

macaela
Messages: 17
Registered: January 2011
Location: UK

Junior Member

found it

begin
helloworld();
end;

Report message to a moderator

Previous Topic:	how to change action menu list title
Next Topic:	ID in procedure after submit is NULL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 09 00:33:16 CDT 2023