Cannot run application from Tutorial 2:How to build a search form

Unknown exception on query:begin :1 := DS_6980.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_6980", line 1415 ORA-06512: at "FORMSPIDER.DS_6980", line 1436 ORA-06512: at line 1 ORA-06512: at "FORMSPIDER.BDF_DBOBJECTACCESS_MNG", line 1505

Error while executing query of datasource "EMPLOYEES1": ORA-01008: not all variables bound

How can I solve this problem?

asked 28 Nov '12, 03:10

Emil's gravatar image

accept rate: 0%

Hi Emil,

This exception occurs when the bind variable used in the datasource definition query is not defined for this datasource definition. Please make sure that you have created a bind variable named "firstName" (note that bind variable names are case sensitive) for the "EMPLOYEE" datasource definition.

In the tutorial, the bind variable creation is explained at the end of section titled "The Model".

Hope this helps. Ibrahim


answered 28 Nov '12, 03:30

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
accept rate: 25%

edited 28 Nov '12, 03:30

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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



Asked: 28 Nov '12, 03:10

Seen: 1,095 times

Last updated: 28 Nov '12, 03:30

Related questions

© Copyright Gerger 2017