So, now I have such a dbproc :
create dbproc prog_one (IN input char(50), OUT outstr char(50)) AS SET outstr = REPLACE (input, '�', 'Ae') outstr ;
But now, my question is, how could I get the outstr ? I tried it with java command :
...<shorted>...
String input = "�chtz";
String output = "";
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery("Call prog_one(" + input + "," + output + ")");
while (rs.next())
{
System.out.println("output : " + output);
}
But there comes the Message : Missing value specification
So, but I guess, I'm right to use an IN and OUT paramter.. ?
Am Wed, 11 Jun 2003 17:24:55 +0200 hat Dittmar, Daniel <[EMAIL PROTECTED]> geschrieben:
I want to write a DBPROC which compares the chars of a string.
If there is one char, which isn't allowed, it has to be replaced by a valid char into that string.
Perhaps you want the TRANSLATE function? http://www.sapdb.org/7.4/htmhelp/71/817395b9b311d2a97100a0c9449261/frameset.htm
Daniel Dittmar
-- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
