calling stored PL/SQL procedures

[Anon]

Is there a way from PHP to call stored PL/SQL procedures? If so, how is this done? Any help would be greatly appreciated.

Thanks.

[Anon]

Compile PHP with OCI8 support. There's all you need to interface with Oracle DB. Including dynaset, statements execution, blobs, bfile and cursor datatype and much more. One except is table datatype.

The steps to execute stored procedure are the following:
- Connect to oracle: OCIConnect
- Parse your statement: OCIParse
- Bind the parameters: OCIBindByName
- Affect input parameters if needed
- Execute the statement: OCIExecute
- Do what you need with output parameters.
- Free statement: OCIFreeStatement
- Close your connection: OCILogoff

Details are in the PHP manual.

[Anon]

Hi, I have a problem with connection to Oracle procedures, hopefully it can be solved.
The platform used is Linux/Oracle8/PHP oci8. The error I get is:

Warning: OCIStmtExecute: ORA-06550: line 1, column 13:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
in /home/test/web/pub/stored_proc_test.php on line 32

Everything work's fine with normal queries sent to the database, only stored procedures can't be called. The same error is returned, no matter the number of arguments or the procedure complexness.
I've seen a similar post by other user who had the same problem, but no one replied to it.

Thanks!

JBL wrote:

Compile PHP with OCI8 support. There's all you need to interface with Oracle DB. Including dynaset, statements execution, blobs, bfile and cursor datatype and much more. One except is table datatype.

The steps to execute stored procedure are the following:
- Connect to oracle: OCIConnect
- Parse your statement: OCIParse
- Bind the parameters: OCIBindByName
- Affect input parameters if needed
- Execute the statement: OCIExecute
- Do what you need with output parameters.
- Free statement: OCIFreeStatement
- Close your connection: OCILogoff

Details are in the PHP manual.

[Anon]

hi
the only thing to do is that you must configure your apache compiler and your program file owner env to fit oracle
flowing example
if apache compiler is root
vi .proflie add these
{
ORACLE_SID=MYORC(your sid)
export ORACLE_SID

ORACLE_BASE=/export/home/oracle (your base)
export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product(you home)
export ORACLE_HOME

PATH=$PATH:$ORACLE_HOME/bin
export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH

NLS_LANG=American_America.ZHS16CGB231280 (maybe here answer where )
export NLS_LANG
}

then restart apache,all are ok.

Darko Gapkovski wrote:

Hi, I have a problem with connection to Oracle procedures, hopefully it can be solved.
The platform used is Linux/Oracle8/PHP oci8. The error I get is:

Warning: OCIStmtExecute: ORA-06550: line 1, column 13:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
in /home/test/web/pub/stored_proc_test.php on line 32

Everything work's fine with normal queries sent to the database, only stored procedures can't be called. The same error is returned, no matter the number of arguments or the procedure complexness.
I've seen a similar post by other user who had the same problem, but no one replied to it.

Thanks!

JBL wrote:

Compile PHP with OCI8 support. There's all you need to interface with Oracle DB. Including dynaset, statements execution, blobs, bfile and cursor datatype and much more. One except is table datatype.

The steps to execute stored procedure are the follow....