Error:- ORA-01036: illegal variable name/number
Env:- Crawling Oracle database and views from SP BDC using SSO.
I had used BDC Meta Man to create the ADF file and after that it was giving the below error while doing full crawl. After working with the BDC support, I found out that the Identifiers we specify in the tool are suppose to be unique in data. Once selecting those Unique identifiers, import the ADF file again and crawl from SharePoint, it will work fine.
Log Name: Application
Source: Office SharePoint Server
Date: 3/12/2010 10:08:30 AM
Event ID: 5701
Task Category: Business Data
Computer: server name
Could not run query/stored proceedure 'Select ORACLE STRING QUERY Pooling=True;User ID=readonly;Integrated Security=False;Persist Security Info=false;User ID=readonly;' in App Domain 'DefaultDomain'. The full exception text is: ORA-01036: illegal variable name/number
event xmlns="a href="http://schemas.microsoft.com/win/2004/08/events/event/a>">
Select ORACLE STRING QUERY Pooling=True;User ID=readonly;Integrated Security=False;Persist Security Info=false;User ID=readonly;
ORA-01036: illegal variable name/number