Re: Return a table type vaiable holding BOOLEAN

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 18 Sep 2002 06:40:01 +0200
Message-ID: <as0gou0b864ru55iotq2pa3lv41c4lebag@4ax.com>

On Tue, 17 Sep 2002 23:54:20 -0400, C Chang <cschang_at_maxinter.net> wrote:

>In my procedure, I tried to return (OUT) a table type variable that
>holding BOOLEAN. Even in theory, it works and compiled. However When I
>call the procedure from my ASP page using MDAC 2.6, the process failed
>by saying syntax error. The DB procedure is running with v8.1.6 on NT
>4. AS soon as I chang it to the table type of NUMBER. The problem is
>solved. I looked the reference of MDAC, it accept a boolean type
>record. Does anyone know why? Thanls
>
>C Chang

The Oracle type BOOLEAN is available in PL/SQL *only*

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Sep 17 2002 - 23:40:01 CDT