Subject Re: Stored Proc Problem
Author spencerr99
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> At 02:46 AM 20/09/2003 +0000, you wrote:
> >--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
> >wrote:
> > > At 12:20 AM 20/09/2003 +0000, you wrote:
> > > >I run this:
> > > >
> > > > execute procedure newrowid( 'person', 1 )
> > > >
> > > >I get this:
> > > >
> > > >ISC ERROR CODE:335544327
> > > >
> > > >ISC ERROR MESSAGE:
> > > >invalid request handle
> > > >
> > > >STATEMENT:
> > > >TIBOInternalDataset:
> > >
>"<TApplication>.frmMain.dlgWisql.<TIBOQuery>.<TIBOInternalDataset>."
> > > >
> > > >
> > > >Statement: execute procedure newrowid( 'person', 1 )
> > > >
> > > >Any ideas?
> > >
> > > The query wasn't prepared?
> > >
> > > heLen
> >
> >Sorry, forgot to mention I am running it from IBOConsole. But I get
> >the same result in Java code.
> >
> >This code worked fine in Interbase 6.5, but blows chunks in Firebird.
>
> It doesn't answer the question. But we are in "needle-in-haystack"
> territory here.
> "In Java code" doesn't throw any light on the interface you are using.
>
> For apps using the (supposedly installed) client library, mention
> 1) what version of Firebird you are using
> 2) what version of client your client apps are using (actually read the
> property lists from gds32.dll and fbclient.dll located in the system
dir of
> the client machine)
>
> Can't help otherwise.
>
> heLen

"In Java code" means I am using JDBC via InterClient. Here are the
gory details:

Firebird version: WI-V6.2.972 Firebird 1.0.3
InterClient Version / JDBC driver: InterServer 2.01
gds32.dll: 6.5.0.28
fbclient.dll: 1.5.0.3815

When I run through IBOConsole, it is version 1.1.8.10

TIA,
Spencer