[PHP] oracle 8i stored procedures + php access
Hi, I have a delphi application that uses oracle as db
server with stored procedures (running ok).
I've been trying to make a php version of such
application with no luck so far.
I've created a user to access such thing and I keep
getting the following error
Warning: OCIStmtExecute: ORA-06550: line 3, column 3:
PLS-00905: object
SYSTEM.CAD013_PSQ_RSV is invalid ORA-06550: line 3,
column 3: PL/SQL:
Statement ignored in
/somewhere/test.php on line 20
Warning: OCIFetchInto: ORA-24338: statement handle not
executed in
/somewhere/test.php on line 31
If I try with user system the messages are diferent
Warning: OCIStmtExecute: ORA-06550: line 3, column 3:
PLS-00905: object SYSTEM.CAD013_PSQ_RSV is invalid
ORA-06550: line 3, column 3: PL/SQL:
Statement ignored in
/somewhere/test.php on line 20
Warning: OCIFetchInto: ORA-24338: statement handle not
executed in /somewhere/test.php on line 31
The script follows
putenv(ORACLE_BASE=/u01/app/oracle) ;
putenv(ORACLE_HOME=/u01/app/oracle/product/8.1.7);
putenv(ORACLE_SID=oracle) ;
$usernameOracle=dbuser;
$passwordOracle=dbpassword;
$hostOracle=dbhost;
$tsA = time() ;
$con =
OCIPLogon($usernameOracle,$passwordOracle,$hostOracle);
$tsD = time() ;
$res = OCINewCursor($con);
$stm = OCIParse ( $con,
BEGIN
CAD013_PSQ_RSV(:pkey, :Option, :RES);
END;
);
$name = foo;
$option = 0;
OCIBindByName ( $stm, :pkey, $nome, -1);
OCIBindByName ( $stm, :Option, $option, -1);
OCIBindByName ( $stm, :RES, amp;$res, -1,
OCI_B_CURSOR
);
@OCIExecute ( $stm );
OCIExecute ($res);
$arrError = OCIError($res);
if ($arrError['code'])
{
echo
$arrError['code'].-.$arrError['message'].lt;brgt;;
exit;
}
while (OCIFetchInto($res,amp;$data))
var_dump($data);
}
OCIFreeCursor($stm);
OCIFreeStatement($res);
The stored procedure has one code bellow
IF (vmINT_QtdLines lt;= 0) THEN
-- PHP
raise_application_error(
-20005,
'NAME NOT FOUND'
);
-- DELPHI
-- DBMS_OUTPUT.PUT_LINE('NOTHING
FOUND:'||pkey);
-- RAISE Erro;
END IF;
I am not quite sure where the problem is located. Any
help (if directly related to oracle emails directly)
wl be appreciated.
Thanks.
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
PHP General 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]
[PHP] oracle 8i stored procedures + php access
Hi, I have a delphi application that uses oracle as db
server with stored procedures (running ok).
I've been trying to make a php version of such
application with no luck so far.
I've created a user to access such thing and I keep
getting the following error
Warning: OCIStmtExecute: ORA-06550: line 3, column 3:
PLS-00905: object
SYSTEM.CAD013_PSQ_RSV is invalid ORA-06550: line 3,
column 3: PL/SQL:
Statement ignored in
/somewhere/test.php on line 20
Warning: OCIFetchInto: ORA-24338: statement handle not
executed in
/somewhere/test.php on line 31
If I try with user system the messages are diferent
Warning: OCIStmtExecute: ORA-06550: line 3, column 3:
PLS-00905: object SYSTEM.CAD013_PSQ_RSV is invalid
ORA-06550: line 3, column 3: PL/SQL:
Statement ignored in
/somewhere/test.php on line 20
Warning: OCIFetchInto: ORA-24338: statement handle not
executed in /somewhere/test.php on line 31
The script follows
putenv(ORACLE_BASE=/u01/app/oracle) ;
putenv(ORACLE_HOME=/u01/app/oracle/product/8.1.7);
putenv(ORACLE_SID=oracle) ;
$usernameOracle=dbuser;
$passwordOracle=dbpassword;
$hostOracle=dbhost;
$tsA = time() ;
$con =
OCIPLogon($usernameOracle,$passwordOracle,$hostOracle);
$tsD = time() ;
$res = OCINewCursor($con);
$stm = OCIParse ( $con,
BEGIN
CAD013_PSQ_RSV(:pkey, :Option, :RES);
END;
);
$name = foo;
$option = 0;
OCIBindByName ( $stm, :pkey, $nome, -1);
OCIBindByName ( $stm, :Option, $option, -1);
OCIBindByName ( $stm, :RES, $res, -1, OCI_B_CURSOR
);
@OCIExecute ( $stm );
OCIExecute ($res);
$arrError = OCIError($res);
if ($arrError['code'])
{
echo
$arrError['code'].-.$arrError['message'].br;
exit;
}
while (OCIFetchInto($res,$data))
var_dump($data);
}
OCIFreeCursor($stm);
OCIFreeStatement($res);
The stored procedure has one code bellow
IF (vmINT_QtdLines = 0) THEN
-- PHP
raise_application_error(
-20005,
'NAME NOT FOUND'
);
-- DELPHI
-- DBMS_OUTPUT.PUT_LINE('NOTHING
FOUND:'||pkey);
-- RAISE Erro;
END IF;
I am not quite sure where the problem is located. Any
help (if directly related to oracle emails directly)
wl be appreciated.
Thanks.
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
PHP General 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]
