Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » how do i run a procedure in sql apex
how do i run a procedure in sql apex [message #510794] Tue, 07 June 2011 14:56 Go to next message
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;

Re: how do i run a procedure in sql apex [message #510795 is a reply to message #510794] Tue, 07 June 2011 15:03 Go to previous message
macaela
Messages: 17
Registered: January 2011
Location: UK
Junior Member
found it Cool

begin
helloworld();
end;
Previous Topic: how to change action menu list title
Next Topic: ID in procedure after submit is NULL
Goto Forum:
  


Current Time: Thu Mar 28 20:54:32 CDT 2024