File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
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: http://aspose.com/file-tools
 
subject: Copying VARCHAR2 Data type to a Java Host Variable of String type in embedded SQL
 
Similar Threads
oracle stored procedure problem in 9i
looping in oracle or java
Basic Questions...Please help
Why it fails to update record
java stored procedure problems