Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:45706
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.220.225 as permitted sender)
DomainKey-Status: bad
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :cc:content-type:content-transfer-encoding;
        b=Nc0gjdqq8TRYE3EA4tF77c7ZZs+cGDyXDNUYXH5W2c8wCGf+dnD1BG7PfSzMJApmXB
         9Xxh5gdWd6bkYnfR/+mQRzJFZxFwFS8ZeQFoncXQhgcz7wxpkaDR94qRwqe1dlz9m471
         ruOfCEgXRxmep2XJibcILswyspr6JhPbKtZ5E=
MIME-Version: 1.0
In-Reply-To: <4ACED592.7070807@oracle.com>
References: <1255038690.10759.9.camel@samuel-laptop> <4ACE6613.808@oracle.com>
	 <1255067917.4144.4.camel@samuel-laptop> <4ACED592.7070807@oracle.com>
Date: Fri, 9 Oct 2009 14:06:01 +0200
Message-ID: <18e9608a0910090506g49e2c122ne176debfd5c8a402@mail.gmail.com>
To: Christopher Jones <christopher.jones@oracle.com>
Cc: internals@lists.php.net
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Subject: Re: [PHP-DEV] Patch: Use notices in PDO
From: samuel.roze@gmail.com (Samuel ROZE)

Well, if I understood, DBMS_OUTPUT returns user's notices or warning,
but no errors ?
In the standart way, in console, how the notices are printed ?

Is DBMS_OUTPUT used both by Pl/SQL function and Oracle functions?

Thanks.
Samuel.

2009/10/9 Christopher Jones <christopher.jones@oracle.com>:
>
> Samuel ROZE wrote:
>> It's a good idea.
>>
>> - PDO::NOTICES_FETCH -> PDO::NOTICES_ENABLED
>> - PDO::NOTICES_NONE  -> PDO::NOTICES_DISABLED
>>
>> That's better ?
>
> That works.
>
>> I see that you are from the Oracle team. Can you explain me how oracle
>> works to raise notices like PostgreSQL ? Or can you build a proof of
>> concept to get notices from Oracle ?
>
> I'm equating your NOTICES to Oracle's DBMS_OUTPUT.  See "Getting
> Output with DBMS_OUTPUT" on p 181 of:
>
> http://www.oracle.com/technology/tech/php/underground-php-oracle-manual.h=
tml
>
> Something similar could be coded in the PDO driver.
>
> The amount of text output could be quite large, depending on the
> user's coding style.  Is your design extensible enough to allow for
> streaming/chunking if the interface needs to be enhanced?
>
> PL/SQL also has compile time warnings and errors that are handled
> differently, see "PL/SQL Success With Information Warnings" on p167.
>
> Chris
>
>
>>
>> Thanks.
>> Samuel.
>>
>> Le jeudi 08 octobre 2009 =C3=A0 15:22 -0700, Christopher Jones a =C3=A9c=
rit :
>>> Samuel ROZE wrote:
>>>> Hi,
>>>>
>>>> I've make a patch which insert notices concepts to PDO. It create:
>>>> - PDO::noticeInfo() - to be like errorInfo
>>>> - PDO::ATTR_LOG_NOTICES, the name of the PDO parameter
>>>>     - PDO::NOTICES_FETCH - fetch notices
>>> I initially took "FETCH" to mean it was related to a query; this
>>> wouldn't always be the case.  What about calling it NOTICES_ENABLE?
>>>
>>> Chris
>>>
>>
>>
>
> --
> Blog: http://blogs.oracle.com/opal
> Twitter:  http://twitter.com/ghrd
>