Prev: Normal residual in GLIMMIX?
Next: FSEdit Question
From: Jérôme on 12 Nov 2009 04:20
Hi,
I would like to know if it's possible to call ORACLE function via a
libname.

Explain : In the Oracle db, i have a funtion to convert id client
(technical id) to external reference (final user reference).

In Oracle, we call this function like this :
select REF_CLIENT_EXTERNE(rcl_cnt.rcl_idt,'101' )
from rcl_cnt;

I have a libname DECI to the Oracle database.
I tried to do this :
proc sql;
create table a as
select deci.REF_CLIENT_EXTERNE(rcl_cnt.rcl_idt,'101' )
from deci.rcl_cnt;
quit;
But i got a message :

14 proc sql;
15 create table a as
16 select deci.REF_CLIENT_EXTERNE(rcl_cnt.rcl_idt,'101' )
_
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &,
*, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,
CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT,
LTT, NE, NET, OR, ^=, |, ||, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

17 from deci.rcl_cnt;

Does someone have an idea ?
Thanks in advance.

Jérôme.
 | 
Pages: 1
Prev: Normal residual in GLIMMIX?
Next: FSEdit Question