CODEWITHSUNDEEP
jdbcxpages
Sebastien
Sebastien

Reputation: 11

xPages calling a stored procedure

Is there a way to call a stored proc from xPages with parameters ?

I am using @JDBCExecuteQuery("oracle",sql,params)

How am I suppose to call the stored procedure ?

What would you put in your SQL line ?

Upvotes: 0

Views: 308

Answers (1)

Oliver Busse
Oliver Busse

Reputation: 3395

AFAIK you cannot use a stored procedure with the @JDBC functions. Instead you can create a Java class/managed bean to call a stored procedure via JDBC. I have an example here how to use JDBC with the Extlib RDBMS features here: https://github.com/zeromancer1972/XPages-JDBC/blob/master/Code/Java/org/openntf/jdbc/DataConnector.java The rules to issue a stored procedure are documented here: https://docs.oracle.com/javase/tutorial/jdbc/basics/storedprocedures.html

Upvotes: 2

Related Questions