creating an Oracle variable...
| From: | bona at trama dot com dot br | Date: | Mon, 10 Sep 2001 19:10:04 +0000 |
| Subject: | creating an Oracle variable... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12315@lists.php.net to get a copy of this message | ||
Hi,
I creat the variable "test" using the sql plus:
var test varchar2(10);
I´ve been trying to do it wiht PHP:
================================================
$comando1 = "exec var test varchar2(10);";
$controle = OCIParse ($connection, $comando1);
if ($controle == false){
echo OCIError($controle)."<BR>";
}
$result1 = OCIExecute ($controle);
================================================
I tryed $comando1 using begin and without the exec... with and without the
";" on the end...
but I allways have the same message: Invalid SQL Command...
can anybody help me???
thanks
Bona
__________________________
Visite http://www.trama.com.br