php3-list | 199807

Re: [PHP3] Stored procedures From: Thies C. Arntzen (thies <email protected>)
Date: 07/30/98

tukker <email protected> wrote:

> L.S.
>
> When I tried to call a stored procedure of oracle with:
>
> $query="execute newTranslation('DEM','NLD')";

execute only works in SQLPlus (AFAIK) you have to use "begin newTranslation('DEM','NLD'); end" to get it
working
regards,
tc

>
>
>
> $result=Ora_Parse($cursor, $query);
> if ($result) {
> $result=Ora_Exec($cursor);
> }
>
> I get: Warning: Ora_Parse failed (ORA-00900: invalid SQL statement -- while processing OCI function OPARSE)
>
> How can I execute a stored procedure from php (even if the procedure has
> no output) ???
>
> Klaasjan Tukker
> Microweb BV
> k.tukker <email protected>
>
> --
> PHP 3 Mailing List http://www.php.net/
> To unsubscribe send an empty message to php3-unsubscribe <email protected>
> To subscribe to the digest list: php3-digest-subscribe <email protected>
> For help: php3-help <email protected> Archive: http://www.php.net/mailsearch.php3
> 

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3