Re: [Squirrel-sql-users] Executing stored procedures for Oracle

[Colin B. <col...@te...>]

Try 

I believe the syntax for Oracle is something like:

begin
asc_version ('3-2-1-030519', 'HP 9Z','Cashier Session Report fix', NULL);
end;

Just remember to change the Statement Separator setting in your session from ; to something else before you try running the procedure.

You could also try the JDBC escape syntax:

{call asc_version ('3-2-1-030519', 'HP 9Z','Cashier Session Report fix', NULL)}

--
Colin Bell
http://squirrel-sql.sf.net

----- Original Message -----
From: Stephen Hull <ste...@as...>
Date: Tuesday, November 18, 2003 4:53 am
Subject: [Squirrel-sql-users] Executing stored procedures for Oracle

> Lots of good functionality to Squirrel-sql.  However, is there a 
> way to
> execute a stored procedure?  
> 
> 
> 
> I can view the procedure source, I can do "create and replace
> procedure", but I can not execute the procedure.  For example:
> 
> 
> 
> execute asc_version ('3-2-1-030519', 'HP 9Z','Cashier Session Report
> fix', NULL);
> 
> 
> 
> Any suggestions?
> 
> 
> 
> Thanks,
> 
> 
> 
> Steve
> 
> 
> 
> Stephen Hull
> 
> ASIX, Inc.
> 
> 
> 
>