JDBC sender from view

[Former Member]

Hey,

is it posible in xi 7.1 to trigger a view (not a single table) in oracle DB ?

[Former Member · Accepted solution]

hey,

tx for ansewring.

i meant what you understood.

is there something different in the sql statement that i need to do ?

[Former Member · Accepted solution]

No. Just use the view name instead of table name in the Select/update statements.

[Former Member]

never mind i have found the problem.

[Former Member]

I'm using the following string for select from the view:

"SELECT * FROM TABLE(CUSTOMER_CRM_DATA)"

CUSTOMER_CRM_DATA represents the view

and getting the error: "Database-level error reported by JDBC driver while executing statement 'SELECT * FROM TABLE(CUSTOMER_CRM_DATA)'. The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-00904: "CUSTOMER_CRM_DATA": invalid identifier '. For details, contact your database server vendor"

help

[Former Member]

Great, TX.

[Former Member]

TX for helping

I didn't see anything about it in the page

Edited by: Zevik Heinoch on Oct 28, 2008 11:09 AM

[Former Member]

Zevik,

You can select/update data from views if that is what you are looking for.

I cant understand "trigger from view"? What do you mean here?

Thanks

Jaishankar

[Former Member]

hi,

Look at the help.sap.com documentation

http://help.sap.com/saphelp_nwpi71/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm