[PHP-DB] Re: OCIStmtExecute: ORA-01008: not all variables bound on Anonymous PL/SQL

Hi, Does anyone know how to get this done? Thanks, "Prince" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > I have the sample php program. While trying to execute, I get the above > mentioned error. > > SQL> create type typ_numbertab TABLE OF n

[PHP-DB] Binding host variable to Oracle Object type (Nested Table)

Hi! I have an oracle object type as follows, create or replace type my_objtype as object (col1 number, col2 number) / create or replace type my_arrtype as table of my_objtype / I couldn't get this bound in php. If I have an simple oracle object type (see the below one), I could bind it and pa

Re: [PHP-DB] How do I assign Oracle pakage variable's value to aphp variable?

Hello! Hasn't anyone got this working ? "Prince Kumar" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > I was thinking the same. But I believe there should be a better way. (We > do't want to pass the package variables as OUT variable in a

[PHP-DB] How do I assign Oracle pakage variable's value to a php variable?

Hello, I have a package like the following one. creare or replace package my_pkg as my_pkg_var varchar(10) defalut 'myVal'; end my_pkg ; Now, I want to read this value into a php variable (say $my_php_var). How do I do this? in PL/SQL, I can easily do this as declare tmp varchar2(10);

Re: [PHP-DB] Re: LOBS with CURSOR_SHARING=FORCE gives core dump

d ; / "Thies C. Arntzen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Mon, Apr 15, 2002 at 04:31:06PM -0700, Prince wrote: > > I don't think this is the bug with oracle as I was able to do the same with > > C pr

[PHP-DB] Re: LOBS with CURSOR_SHARING=FORCE gives core dump

e LOB, and restore > cursor_sharing=force after the update. > > ALTER SESSION SET cursor_sharing=exact > > Bye, John > > "Prince" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > John! > > >

[PHP-DB] Re: LOBS with CURSOR_SHARING=FORCE gives core dump

John! Thanks for the update. Did you find any work-around for this issue? Thanks, Prince. "John Lim" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hmm, I have also been having similar problems with LOBs. However it might >

[PHP-DB] LOBS with CURSOR_SHARING=FORCE gives core dump

s seems to be happening only when LOB with returning clause is present. I tested a similar program from "C" program and is fine. Note: currently I have set the parameter (CURSOR_SHARING=FORCE ) only in the program/session level. Thanks, Prince. $ cat curshare.php #!/usr/l