1. creating sybase stored procedure that returns jdbc statement.getWarning stackoverflow.comI am creating a sybase stored prodedure that is being called through JDBC. Under certain error conditions i want my stored procedure to return a warning to the JDBC caller. ... |
2. Stored procedure to java attributes stackoverflow.comI have a bunch of Sybase SP's for CRUD operations that I need to create services for in the mid-tier layer. All the SP's are in place but the mid-tier has ... |
3. Sybase Stored Procedures coderanch.com |
4. Retrieiving OUT parameters & return value from a Sybase Stored Procedure coderanch.comHi all!! I am using JConnect52 JDBC driver to connect to Sybase Adaptive Server Anywhere 6.0. My problem is this: I am unable to retrieve the OUT parameter from a Stored Procedure which returns multiple resultsets, a return value & an OUT parameter. Only the resultset & return value is retrieved. On attempting to retrieve the OUT parameter, i get an ... |
5. JDBC Sybase Stored Procedure Exception coderanch.comHi, I have met same issue in our app. I created preparedStatement, set all inputs and outputs and execute it. Nothing happen when I threw error inside called SP. Solution which works for me is add just simple read of output value which throws exception... ... try{ stmt = m_dbConnection.prepareCall("{?=call my_sp ?}"); stmt.registerOutParameter(1, java.sql.Types.INTEGER); stmt.setString(2, "MyStringValue"); stmt.execute(); // pass without exception ... |
7. Java and Sybase nested stored procedures coderanch.comHi! I have nested Sybase stored procedures, the main procedure calls a helper stored proc. The main procedure returns 2 result sets before calling the helper store proc and helper store proc returns 1 resultset. After the helper store proc is called, the main store proc returns 2 more resultset. When I run it using SQL client tool the main procedure(and ... |
8. Java and Sybase nested stored procedures coderanch.comHi! I have nested Sybase stored procedures, the main procedure calls a helper stored proc. The main procedure returns 2 result sets before calling the helper store proc and helper store proc returns 1 resultset. After the helper store proc is called, the main store proc returns 2 more resultset. When I run it using SQL client tool the main procedure(and ... |
9. Calling Java stored procedure from Sybase ASA 9 dbforums.comTrying to upgrade to ASA 9.0.1.1862 This all worked great under 7.0.4.xxxx, and there have been no changes to the java .jar file, or the classes inside it. I'm going nuts trying to get my java procedure calls to work, even in the simplest test case. I have no problem with the asademo examples, so I know java is installed properly. ... |
10. Calling a Sybase Stored Procedure? (probably easy) forums.oracle.comHi, I'm having problems writing the java code to access the following Sybase prepared statement: one input and one output. Here is the ansi-sql version: /* begin */ declare @id numeric(20) declare @res int EXEC @res = example_prepared_statement 80000500000000000032, @id out update example_table set example_column='hello world' where id=@id /* end */ Any help would be greatly appreciated! |