ORA-24334 when creating a stored procedure based datawindow

Junaid Siddiqui

unread,

Jul 14, 2003, 3:40:53 PM7/14/03

to

Hi Bruce,
How can I check the value that the powerbuilder sends to the stored
procedure because it gives me the error. Also, do you know what dummy value
does it pass to the stored procedure. For example, my parameters are
varchar2 and the first line in the stored procedure that uses those
parameters creates the error. Would you please elaborate on your solution.

Thanks
Junaid

"Bruce Armstrong [TeamSybase]" <NOCANSPAM_br...@teamsybase.com>
wrote in message news:Ot$PnyjSDHA.344@forums-2-dub...
> When PB is setting up a datawindow with a stored procedure as the
> datasource, it actually invokes the stored procedure passing a dummy
value.
> That can actually cause errors if the value is something that the
procedure
> isn't expecting. You might want to add something to the stored procedure
to
> check for the value that PB passes when intially setting up the
DataWindow.
>
> --
> Bruce Armstrong [TeamSybase]
> http://www.teamsybase.com
>
> Two new books on developing with PowerBuilder
> http://www.pb9books.com?source=newsgroups
>
> Need code sample? Check out CodeXchange:
> http://www.codexchange.sybase.com
>
> Preach the gospel at all times. If necessary, use words. - Francis of
Assisi
> http://www.needhim.org
>
>
> "Junaid Siddiqui" <junaid....@health.state.mn.us> wrote in message
> news:e2W1PsjSDHA.346@forums-2-dub...
> > Hello,
> > I'm using PB 8 with Oracle 8i. I'm trying to create a datawindow
with
> a
> > stored procedure as its source but when I click on 'Finish' button in
the
> > datawindow wizard, I get the oracle error ORA-24334 which is talking
about
> > not having some descriptor handle.The funny thing is that if I remove
the
> > only line in the procedure referencing the arguments of the procedure, I
> can
> > create the datawindow without a problem.
> >
> > I have other datawindows that are based on similar stored procedures
and
> > they don't give me any problem. I would appreciate any input.
> >
> > Thanks
> > Junaid
> >
> >
>
>

Junaid Siddiqui

unread,

Jul 14, 2003, 2:58:17 PM7/14/03

to

Bruce Armstrong [TeamSybase]

unread,

Jul 14, 2003, 3:09:43 PM7/14/03

to

When PB is setting up a datawindow with a stored procedure as the
datasource, it actually invokes the stored procedure passing a dummy value.
That can actually cause errors if the value is something that the procedure
isn't expecting. You might want to add something to the stored procedure to
check for the value that PB passes when intially setting up the DataWindow.

--
Bruce Armstrong [TeamSybase]
http://www.teamsybase.com

Two new books on developing with PowerBuilder
http://www.pb9books.com?source=newsgroups

Need code sample? Check out CodeXchange:
http://www.codexchange.sybase.com

Preach the gospel at all times. If necessary, use words. - Francis of Assisi
http://www.needhim.org

"Junaid Siddiqui" <junaid....@health.state.mn.us> wrote in message
news:e2W1PsjSDHA.346@forums-2-dub...

Bruce Armstrong [TeamSybase]

unread,

Jul 14, 2003, 7:36:25 PM7/14/03

to

Turn on database tracing and you'll see what's being sent in the trace file.

--
Bruce Armstrong [TeamSybase]
http://www.teamsybase.com

Two new books on developing with PowerBuilder
http://www.pb9books.com?source=newsgroups

Need code sample? Check out CodeXchange:
http://www.codexchange.sybase.com

Preach the gospel at all times. If necessary, use words. - Francis of Assisi
http://www.needhim.org

"Junaid Siddiqui" <junaid....@health.state.mn.us> wrote in message

news:ur4NDEkSDHA.346@forums-2-dub...