|
From: Colin B. <Col...@as...> - 2001-11-15 05:23:58
|
Hi Simon,
There seem to be different ways to execute stored procs on different
platforms. On Oracle for instance to call PROC1 I can key the following into
SQuirreL:
begin
PROC1;
end;
For Interbase this works:
select * from proc1
Unfortunately I don't have access to Sybase so I can't try it out.
Some different syntaxes you could try are:
call proc1
call proc1()
and wrapping the JDBC escape syntax aroung the proc:
{call proc1}
{call proc1()}
Sorry I couldn't be more help.
Col
-----Original Message-----
From: Simon Rose [mailto:sim...@so...]
Sent: Thursday, 15 November 2001 2:59
To: squ...@li...
Subject: [Squirrel-sql-users] squirrel request
I've just been playing with SQuirreL - Love it - very cool. I'm connecting
to
a Sybase server using the Sybase Jconnect JDBC drivers (v5.5), I'm unable to
execute stored procedures. Is that a feature of the driver or a feature of
SQuirreL? Perhaps I'm missing a setting somewhere. If not could that be
added
to the the wish list please.
regards
Simon Rose.
Principle Consultant
Sophia Software Ltd.
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|
