RE: Esql and Oracle Functions

2003-10-10 Thread Martin Samm
-Wakefield [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 14:46 To: [EMAIL PROTECTED] Subject: RE: Esql and Oracle Functions That makes sense. What is the java code that you would use to directly access this function? How does it differ from the code generated by ESQL? Once you know that, it should

RE: Esql and Oracle Functions

2003-10-10 Thread Wilson, Colin
ECTED] Sent: 10 October 2003 14:46 To: [EMAIL PROTECTED] Subject: RE: Esql and Oracle Functions That makes sense. What is the java code that you would use to directly access this function? How does it differ from the code generated by ESQL? Once you know that, it should be pretty easy to e

RE: Esql and Oracle Functions

2003-10-10 Thread Christopher Painter-Wakefield
| | cc: | | Subject: RE: Esql and Oracle Functions | >-

RE: Esql and Oracle Functions

2003-10-10 Thread Wilson, Colin
ideas ...? -Original Message- From: Martin Samm [mailto:[EMAIL PROTECTED] Sent: 09 October 2003 15:52 To: [EMAIL PROTECTED] Subject: RE: Esql and Oracle Functions i haven't used ESQL, but getting the result of a function should be the same as performing a select. E.g. select 1 from

RE: Esql and Oracle Functions

2003-10-09 Thread Martin Samm
i haven't used ESQL, but getting the result of a function should be the same as performing a select. E.g. select 1 from dual For a function it would be select package.function(param1,param2,...) from dual; Then retrieve the first column (getInt(1), say in JDBC) as you would with the column va