Knowledgebase
When the datawindow syntax beginning with the non-select key words syntax, Appeon will resolve to execute Procedure, leading to implementation failure.
Posted by Support Appeon on 04 July 2011 02:45 PM

When the datawindow syntax beginning with the non-select key words syntax, Appeon will resolves to execute Procedure, leading to implementation failure. Such as below data window sql syntax.

with tmp as(select emp_id from employees )   

select a.emp_id from employees a, tmp b

where a. emp_id = b. emp_id

and rownum < 5;

end pro_with_test;

 

Workaround:

Move datawindow sql to a stored procedure and then create datewindow to use that stored procedure as data source to work around this issue.

 

CREATE OR REPLACE PACKAGE ods is

   type rec_set is ref cursor;

end ods;

 

CREATE OR REPLACE PROCEDURE pro_with_test(rcl out ods.rec_set)

is

begin

  open rcl for

  with tmp as(select emp_id from employees )   

select a.emp_id from employees a, tmp b

where a. emp_id = b. emp_id

and rownum < 5;

end pro_with_test;

(1 votes)
This article was helpful
This article was not helpful

Comments (0)
Post a new comment 
 

Please login if you wish to leave a comment about this article.

Help Desk Software by Kayako Fusion