Create stored procudere in PHP ? [message #4230] |
Wed, 20 November 2002 10:11 |
Ro
Messages: 3 Registered: November 2002
|
Junior Member |
|
|
Is it possible to create or update a stored proc in PHP ?
if I insert a row into User_source table, will Oracle consider it as a stored procedure or not ?
Thank
best regards,
Ro
|
|
|
|
Re: Create stored procudere in PHP ? [message #4272 is a reply to message #4230] |
Sun, 24 November 2002 06:15 |
Ro
Messages: 3 Registered: November 2002
|
Junior Member |
|
|
my problem is that I cannot create a stored procedure within PHP.
when I run a query like this "Create Procedure ro as begin htp.p('hell'); end ro;", php will return a warning "Warning: OCIStmtExecute: OCI_SUCCESS_WITH_INFO in /home/httpd/html/djn/inc/db_fns.php on line 36 " however there is a procedure named "ro" in user_source view, but when I access www.myserver.com/pls/myDAD/ro, Oracle returns a error complaining that procedure "ro" doesn't exist.
help, please.
thanks.
best regards,
Ro.
|
|
|