Re: [PHP-DB] ociNewCollection and package

2001-12-12 Thread Olaf Taesch 

Hi Sumesh,

> I didn't exactly understand what u mentioned in your email. 
> Do u mean that
> ociNewCollection is still not working?

No - it works, but not if the array - type is declared in the package...
or I make a mistake...

regards
Olaf

> 
> 
>   hello sumesh,
> 
>   no, we solved our problem with the oci not an i got no 
> answer to solved
> it. But that is not so important, because the convertion asp 
> code to php is
> canceled in the moment...
>   the links for oci i know are:
>   http://www.php-center.de/de-html-manual/ref.oci8.html
>   
> http://www.phpcenter.de/faq/faq-database_oracle.html?druckversion=yes
>   http://www.php.net/manual/en/ref.oci8.php
>   http://conf.php.net/pres/index.php?p=slides%2Foci&id=oci
> 
>   regards
>   olaf
> -Original Message-
> From: Sumesh Nair [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 22, 2001 4:37 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] ociNewCollection and package
> 
> 
> Hello,
> 
> I found your email id  on phpBuilder on your posting for [PHP-DB]
> ociNewCollection and package.
> I am sorry to contact you directly but I have done so 
> because I have not
> been successful in finding any solution to the OCITypeByName: 
> OCI-22303:
> type problem. Have you solved the problem of ociNewCollection.
> 
> If so pl. let me know or if u have some documentation it 
> would be if I
> could have a look.
> 
> Thanking u in advance
> 
> Sumesh
> 
> Sumesh Nair
> Frontend Developer, Flytxt Ltd.
> 5-15 Cromer St. London WC1H 8LS
> [EMAIL PROTECTED]
> www.flytxt.com
> t: +44-207-841-6410
> f: +44-207-841-6444
> m: +44 781-071-8822
> 
> 
> 
> 

-- 
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]

RE: [PHP-DB] ociNewCollection and package

2001-12-06 Thread Sumesh Nair 

Hi Olaf,

Thanks for your reply.
I didn't exactly understand what u mentioned in your email. Do u mean that
ociNewCollection is still not working?
 So how did u solve your problem of sending arrays from php to oracle? I had
look a at the links u sent me but there is no documention on sending arrays
to oracle.
Any info would be helpful. Thanks

regards
Sumesh
  -Original Message-
  From: Olaf Taesch [mailto:[EMAIL PROTECTED]]
  Sent: 03 December 2001 18:09
  To: 'Sumesh Nair'
  Subject: RE: [PHP-DB] ociNewCollection and package


  hello sumesh,

  no, we solved our problem with the oci not an i got no answer to solved
it. But that is not so important, because the convertion asp code to php is
canceled in the moment...
  the links for oci i know are:
  http://www.php-center.de/de-html-manual/ref.oci8.html
  http://www.phpcenter.de/faq/faq-database_oracle.html?druckversion=yes
  http://www.php.net/manual/en/ref.oci8.php
  http://conf.php.net/pres/index.php?p=slides%2Foci&id=oci

  regards
  olaf
-Original Message-
From: Sumesh Nair [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 22, 2001 4:37 PM
To: [EMAIL PROTECTED]
    Subject: Re: [PHP-DB] ociNewCollection and package


Hello,

I found your email id  on phpBuilder on your posting for [PHP-DB]
ociNewCollection and package.
I am sorry to contact you directly but I have done so because I have not
been successful in finding any solution to the OCITypeByName: OCI-22303:
type problem. Have you solved the problem of ociNewCollection.

If so pl. let me know or if u have some documentation it would be if I
could have a look.

Thanking u in advance

Sumesh

Sumesh Nair
Frontend Developer, Flytxt Ltd.
5-15 Cromer St. London WC1H 8LS
[EMAIL PROTECTED]
www.flytxt.com
t: +44-207-841-6410
f: +44-207-841-6444
m: +44 781-071-8822

[PHP-DB] ociNewCollection and package

2001-09-26 Thread Olaf Taesch 

Hi,

following the example in conf.php.net/oci with declaring the typ 
outside a package is runs!

trying in php
$arr = OCINewCollection($conn,"TEST.ARR_CHAR");

only brings:
Warning: OCITypeByName: OCI-22303: type ""."TEST_OLE.ARR_CHAR" not found 

but the type ARR_CHRR declared in the package

CREATE OR REPLACE PACKAGE TEST IS
   TYPE ARR_CHAR IS VARRAY(100) OF VARCHAR2(100);
   PROCEDURE xxx(p_xxx  in  ARR_CHAR);
END TEST;
/

CREATE OR REPLACE PACKAGE BODY TEST AS
PROCEDURE xxx(p_xxx in  ARR_CHAR) IS
BEGIN
...


any ideas?
thanks!
Olaf


-- 
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]