Hi. I got this error. please help me . Unknown exception on query:begin :1 := DS_15655.loadData(:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16); exception when bdf_datasource_mng.e_invalidFilterClause then :17 := 'N'; end; Unknown exception on:ORA-06512: at "FORMSPIDER.DS_15655", line 565 ORA-06512: at "FORMSPIDER.DS_15655", line 1179 ORA-06512: at line 1 ORA-06512: at "FORMSPIDER.BDF_DBOBJECTACCESS_MNG", line 1505

ORA-00036: maximum number of recursive SQL levels (50) exceeded

asked 02 Nov '12, 01:35

lezgin's gravatar image

lezgin
71421
accept rate: 0%


Hi,

It seems a deadlock. This error may occur if you execute the query of the datasource on its postQuery or currentRowChanged event. Can you please check where you get the error (which api) and find the datasource. Then please check events of your datasource.

link

answered 02 Nov '12, 01:43

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
5616
accept rate: 23%

currentRowChanged event.

procedure user_grants_show is v_user_id number; begin -- get id of the currently selected user v_user_id := api_datasource.getColumnValueNR('users1.ID'); -- populate grants belonging to the selected id api_datasource.setBindvar('MODULE_PRIV1.userid', v_user_id); api_datasource.executeQuery('MODULE_PRIV1'); end;

(02 Nov '12, 01:44) lezgin

I got error. I was set in two datasource same procedure. Now i fixed it. and worked. Sorry Ugur

(02 Nov '12, 01:46) lezgin
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×5
×4

Asked: 02 Nov '12, 01:35

Seen: 1,044 times

Last updated: 07 Nov '12, 05:17


© Copyright Gerger 2017