Bona,
You are trying to perform an SQL*PLUS command. I think
you can only perform SQL commands with OCI. You can
print a ref cursor in SQL*PLUS but you have to handle it
differently with OCI. Look at the PHP reference manual for
ocinewcursor.
Good Luck,
Pat
[EMAIL PROTECTED] wrote:
> Hi again.
>
> now I�m writing to solve another puzzle of my script...
>
> on the SQL*Plus I type the following code to get x value:
>
> print x;
>
> I trying to do it with PHP this way:
>
> <?
>
> $conn = OCILogon ("SYSTEM","manager");
>
> $cursor = OCIParse ($conn, "print x;end;");
>
> OCIBindByName ($cursor, ":x", $x, 10);
>
> $result = OCIExecute ($cursor);
>
> echo $result;
>
> ?>
>
> and this is my error message:
>
> Warning: OCIBindByName: ORA-01036:not valid name/number in c:\program
> files\apache group\apache\htdocs\apostila\testes\procedure01f.php on line 7
>
> Warning: OCIStmtExecute: ORA-06550: line 1, row 14: PLS-00103: Found "X"
> when one of the followed were espected: := . ( @ % ; O s�mbolo ":=" in c:
> \program files\apache group\apache\htdocs\apostila\testes\procedure01f.php
> on line 9
>
> any sugestions???
>
> thanks for all the help I having from you!!!
>
> Bona
>
> __________________________
> Visite http://www.trama.com.br
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
