cancel
Showing results for 
Search instead for 
Did you mean: 

SQL insert from input form works fine - how also select to output table?

Former Member
0 Kudos

Using a JDBC system to an Oracle DB I am writing SQL to do inserts. This works fine by writing the insert statement in the "SQL_STATEMENT" field found by clicking on the line between the input form and the inpurt port of the data service (db table):

"insert into felles.vc_test (name, sg, user_id) values ('" &@NAME& "', " &@SG& ", '" &@USER_ID& "')"

Now I also want the user to see that the insert was successful. I am thinking either to give the user a pop up message showing the data that was inserted, or to automatically update an output table triggered by the submit action on the insert form.

Dragging an output table from the data service's output port does not work by default. I get an "application error !Null".

How do I do this?

Henning

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

I have the same problem but I only need to do an update statement. The updates goes to the db (Oracle) just fine. At this point I could even live without the confirmation but I can't seem to stop the Null message.

Anyone have any ideas?

Thanks

Mark Chadwick

CSA Group

Former Member
0 Kudos

Remove the output table. If you only have the data service with an entry form and write your insert sql on the line between these, the null message disappears.

Henning

Former Member
0 Kudos

The easiest way I can think of to do this is use a stored procedure that has output messaging. Then if you connect via Portal JDBC instead of BI JDBC, you can access stored procedures for this. It'll be a lot easier handling it this way rather than trying to handle this with SQL Editor in VC.

Former Member
0 Kudos

Unfortunately i am deploying my model to netweaver 2004 where only BI JDBC systems will work. Therefore I cannot use stored procedures. I have to get this to work using SQL.

Any tips?

Henning