Thread: Re: [Squirrel-sql-users] Executing stored procedures for Oracle
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Colin B. <col...@te...> - 2003-11-18 04:49:52
|
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. > > > > |
From: Maury H. <mh...@cr...> - 2003-11-18 17:41:09
|
Colin Bell wrote: > I believe the syntax for Oracle is something like: > > begin > asc_version ('3-2-1-030519', 'HP 9Z','Cashier Session Report fix', NULL); > end; Yes, that is the correct syntax (My understanding is that 'execute' is a SQL*Plus-specific thing. SQL*Plus drops the execute and wraps a begin/end around the line of code in the background). You can also do: declare ... begin ... end; if you need to define variables that are used in the PL/SQL block. > Just remember to change the Statement Separator setting in your session from ; > to something else before you try running the procedure. Ah, that's how you do it. I was wondering why I could never get a begin/end block to work. I thought that block was getting split up into multiple statements, but for whatever reason changing the Statement Separator didn't occur to me. Thanks Colin. (this may be something for a FAQ?) Colin, just out of curiosity, does the SQuirreL Plug-In API have anything that would allow a plug-in to define code-block initiators/terminators (i.e. begin/end or declare/end) to tell SQuirreL not to split those blocks up into multiple statements, irregardless of the current Statement Separator? > You could also try the JDBC escape syntax: > > {call asc_version ('3-2-1-030519', 'HP 9Z','Cashier Session Report fix', NULL)} That doesn't appear to work with Oracle. When I try this, I get a error: "Error: java.sql.SQLException: ORA-00928: missing SELECT keyword". Maury... -- Maury Hammel Cronus Technologies Inc. http://www.cronustech.com |
From: Stephen H. <ste...@as...> - 2003-11-19 02:06:55
|
To execute the procedure, this is what I did: call asc_version('3-2-1-030519', 'HP 9Z','Cashier Session Report fix',NULL); That's all there was to it. Did not have to use begin/end block, just a simple call. Thanks for the help. Steve Stephen Hull ASIX, Inc. -----Original Message----- From: squ...@li... [mailto:squ...@li...] On Behalf Of Maury Hammel Sent: Tuesday, November 18, 2003 9:40 AM Cc: squ...@li... Subject: Re: [Squirrel-sql-users] Executing stored procedures for Oracle Colin Bell wrote: > I believe the syntax for Oracle is something like: > > begin > asc_version ('3-2-1-030519', 'HP 9Z','Cashier Session Report fix', NULL); > end; Yes, that is the correct syntax (My understanding is that 'execute' is a SQL*Plus-specific thing. SQL*Plus drops the execute and wraps a begin/end around the line of code in the background). You can also do: declare ... begin ... end; if you need to define variables that are used in the PL/SQL block. > Just remember to change the Statement Separator setting in your session from ; > to something else before you try running the procedure. Ah, that's how you do it. I was wondering why I could never get a begin/end block to work. I thought that block was getting split up into multiple statements, but for whatever reason changing the Statement Separator didn't occur to me. Thanks Colin. (this may be something for a FAQ?) Colin, just out of curiosity, does the SQuirreL Plug-In API have anything that would allow a plug-in to define code-block initiators/terminators (i.e. begin/end or declare/end) to tell SQuirreL not to split those blocks up into multiple statements, irregardless of the current Statement Separator? > You could also try the JDBC escape syntax: > > {call asc_version ('3-2-1-030519', 'HP 9Z','Cashier Session Report fix', NULL)} That doesn't appear to work with Oracle. When I try this, I get a error: "Error: java.sql.SQLException: ORA-00928: missing SELECT keyword". Maury... -- Maury Hammel Cronus Technologies Inc. http://www.cronustech.com ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
From: Colin B. <col...@bi...> - 2003-12-01 09:52:38
|
On Wed, 2003-11-19 at 04:40, Maury Hammel wrote: > Ah, that's how you do it. I was wondering why I could never get a > begin/end block to work. I thought that block was getting split up into > multiple statements, but for whatever reason changing the Statement > Separator didn't occur to me. Thanks Colin. (this may be something for > a FAQ?) Certainly is. I've added it to the list. > > Colin, just out of curiosity, does the SQuirreL Plug-In API have > anything that would allow a plug-in to define code-block > initiators/terminators (i.e. begin/end or declare/end) to tell SQuirreL > not to split those blocks up into multiple statements, irregardless of > the current Statement Separator? Not yet. If you want to send me a patch it will have :-) Colin Bell http://squirrel-sql.sf.net |