OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » ORA-06550: line 1, column 43: PL/SQL: ORA-00928: missing SELECT keyword

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » ORA-06550: line 1, column 43: PL/SQL: ORA-00928: missing SELECT keyword (Application Express, 4.0, windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-06550: line 1, column 43: PL/SQL: ORA-00928: missing SELECT keyword [message #534030]

Fri, 02 December 2011 05:17

abarnybox
Messages: 49
Registered: November 2011

Member

Hi,

Encounterring this error when I try and submit a page:
ORA-06550: line 1, column 43: PL/SQL: ORA-00928: missing SELECT keyword ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored
I think the problem is the ARP because the error underneath is the one from that.
The thing is when I go into the ARP process there is nowhere where I might be able to right a PL/SQL statement or correct one, and even if there was, I don't actually know PL/SQL so not much I would be able to do...
Anyone know what the problem is/how to sort it?

thanks

abarnybox

Report message to a moderator

Re: ORA-06550: line 1, column 43: PL/SQL: ORA-00928: missing SELECT keyword [message #534055 is a reply to message #534030]

Fri, 02 December 2011 06:40

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you, perhaps, set some item's source to be SQL Query but then abandoned the idea and removed the SELECT statement, but forgot to return source type to its previous value (such as Static assignment)?

Report message to a moderator