How to call a stored procedure using a ref cursor on oracle with squirrel

Posted by rapdum on Stack Overflow See other posts from Stack Overflow or by rapdum
Published on 2010-04-14T15:10:36Z Indexed on 2010/04/14 15:13 UTC
Read the original article Hit count: 541

Filed under:

ref-cursor

|

squirrel-sql

|

Oracle

Hello,

I'm trying to do the same request i'm using in Toad

(the store proc signature is two varchar2 parameter and one REF CURSOR parameter)

Here is what I do with Toad

variable myCursor refcursor;
EXEC myproc('param1','param2',:myCursor );
print myCursor;

I don't know how to write this with Squirrel and I have to use Squirrel.

thanks a lot for your response

Raphaël

© Stack Overflow or respective owner

Related posts about ref-cursor

How to call a stored procedure using a ref cursor on oracle with squirrel

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm trying to do the same request i'm using in Toad (the store proc signature is two varchar2 parameter and one REF CURSOR parameter) Here is what I do with Toad variable myCursor refcursor; EXEC myproc('param1','param2',:myCursor ); print myCursor; I don't know how to write this with… >>> More
Returning ref cursor from oracle stored procedure by using DAAB form MS EntLib 4.1

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to get ref cursor from oracle stored procedure by using DAAB from Microsoft Enterprise Library 4.1? >>> More
Returning ref cursor from oracle stored procedure by using DAAB from MS EntLib 4.1

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to get ref cursor from oracle stored procedure by using DAAB from Microsoft Enterprise Library 4.1? >>> More
Getting a ResultSet/RefCursor over a database link

as seen on Stack Overflow - Search for 'Stack Overflow'
From the answers to http://stackoverflow.com/questions/1122175/calling-a-stored-proc-over-a-dblink it seems that it is not possible to call a stored procedure and get the ResultSet/RefCursor back if you are making the SP call across a remote DB link. We are also using Oracle 10g. We can successfully… >>> More
How to bulk insert data from ref cursor to a temporary table in PL/SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Could anyone tell me how to bulk insert data from a ref cursor to a temporary table in PL/SQL? I have a procedure that one of its parameters stores a result set, this result set will be inserted to a temporary table in another stored procedure. This is my sample code. CREATE OR REPLACE PROCEDURE… >>> More

Related posts about squirrel-sql

SQuirrelSQL redirect ouput to a file?

as seen on Super User - Search for 'Super User'
Does anybody knows if SQuirrel SQL client may output the of several SQL commands to a single result window in textplain or to a file ( as SQL+ would ) So I can: select * from dual; select * from dual; And have both results in a single "ready to" Ctrl-C format? >>> More
SQL – NuoDB and Third Party Explorer – SQuirreL SQL Client, SQL Workbench/J and DbVisualizer

as seen on SQL Authority - Search for 'SQL Authority'
I recently wrote a four-part series on how I started to learn about and begin my journey with NuoDB. Big Data is indeed a big world and the learning of the Big Data is like spaghetti – no one knows in reality where to start, so I decided to learn it with the help of NuoDB. You can download NuoDB and… >>> More
Java: "Could not find the main class. Program will exit"

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to run SQuirreL SQL. I've downloaded it and installed it, but when I try to run it I get this error message: Java Virtual Machine Launcher. Could not find the main class. Program will exit. I get the gist of this, but I have not idea how to fix it. Any help? more info: I'm… >>> More
How to translate CCSID 65535 in SQuirrel from a DB2 on an iseries

as seen on Stack Overflow - Search for 'Stack Overflow'
I am new to SQuirrel SQL. I need some help to translating CCSID 65535 into ASCII, UNICODE (or anything human readable) I am using the JDBC driver per the following guide. According to IBM's website: What character conversion issues must my program deal with? The IBM i database uses EBCDIC… >>> More
generate sql script from tables

as seen on Stack Overflow - Search for 'Stack Overflow'
is it possible to generate sql scripts from for all tables ? i want to generate the sql script and import into another database server >>> More