aspose file tools
The moose likes JDBC and the fly likes Copying VARCHAR2 Data type to a Java Host Variable of String type in embedded SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Copying VARCHAR2 Data type to a Java Host Variable of String type in embedded SQL" Watch "Copying VARCHAR2 Data type to a Java Host Variable of String type in embedded SQL" New topic
Author

Copying VARCHAR2 Data type to a Java Host Variable of String type in embedded SQL

sharath kv
Greenhorn

Joined: May 06, 2003
Posts: 20
Hi
I would like to know 2 things:
1) Is it possible to copy varchar2 type to a java host variable of type String in an
Anonymous PL/SQL in SQLJ.
Eg:
String var1; // Java String variable var1
String a;
String x;

try { // PL/SQL Block begins here
#sql {
DECLARE
b varchar2(2000);
msg varchar2(2000);
ret boolean;

BEGIN
ret:=di.func(:IN var1, UT a,msg);
b := UT a; //Unable to copy from a to b??
ret1:=ni.func2(:IN b, UT x,msg);
-- Unable to use :IN b i,e the output buffer
-- of the above procedure as input to
-- another procedure
END;
};
catch(SQLException e) { }
2) My Second question is
Looking at the above code how do I pass the OUT buffer returned from one procedure as input to another procedure.
 
I agree. Here's the link: jrebel
 
subject: Copying VARCHAR2 Data type to a Java Host Variable of String type in embedded SQL
 
Similar Threads
java stored procedure problems
Why it fails to update record
Basic Questions...Please help
oracle stored procedure problem in 9i
looping in oracle or java