How do I call Oracle stored procedures that take no parameters?
Submitted by: AdministratorHere is what we use that works:
CallableStatement cstmt = conn.prepareCall("Begin procName;
END;");
cstmt.execute();
where procName is the name of an Oracle stored procedure. This is standard Oracle SQL syntax that works with any Oracle DBMS. You might also use the following syntax:
CallableStatement cstmt = conn.prepareCall("{call procName};");
cstmt.execute();
This code, which conforms to the Java Extended SQL spec, will work with any DBMS, not just Oracle.
Submitted by: Administrator
CallableStatement cstmt = conn.prepareCall("Begin procName;
END;");
cstmt.execute();
where procName is the name of an Oracle stored procedure. This is standard Oracle SQL syntax that works with any Oracle DBMS. You might also use the following syntax:
CallableStatement cstmt = conn.prepareCall("{call procName};");
cstmt.execute();
This code, which conforms to the Java Extended SQL spec, will work with any DBMS, not just Oracle.
Submitted by: Administrator
Read Online BEA Weblogic Job Interview Questions And Answers
Top BEA Weblogic Questions
| ☺ | Can I use the getAttribute() and setAttribute() methods of Version 2.2 of the Java Servlet API to parse XML documents? |
| ☺ | Which of the following are the benefits of MDB (Message Driven Beans) over standard JMS consumers? |
| ☺ | Why do I get an error while trying to retrieve the text for ORA-12705? |
| ☺ | Why am I getting an ORA-01000: maximum open cursors exceeded error, even though I closed all ResultSet, Statement, and Connection objects? |
| ☺ | Can WebLogic Server start with a UNIX boot? |
Top Application Program Categories
| ☺ | AutoCAD Interview Questions. |
| ☺ | Microsoft Office Interview Questions. |
| ☺ | Microsoft Outlook Interview Questions. |
| ☺ | Microsoft Excel Interview Questions. |
| ☺ | MATLAB Interview Questions. |
