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)
ORA-06550: line 1, column 43: PL/SQL: ORA-00928: missing SELECT keyword [message #534030] Fri, 02 December 2011 05:17 Go to next message
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
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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)?
Re: ORA-06550: line 1, column 43: PL/SQL: ORA-00928: missing SELECT keyword [message #534059 is a reply to message #534055] Fri, 02 December 2011 06:52 Go to previous messageGo to next message
abarnybox
Messages: 49
Registered: November 2011
Member
No, the items source are all: Item (Application or page item name)
Re: ORA-06550: line 1, column 43: PL/SQL: ORA-00928: missing SELECT keyword [message #534089 is a reply to message #534059] Fri, 02 December 2011 09:49 Go to previous message
abarnybox
Messages: 49
Registered: November 2011
Member
Turns out I have to change all the layout so this is irrelevant now, thanks anyway
Previous Topic: How do I pass arguments between pages
Next Topic: LOV for time
Goto Forum:
  


Current Time: Thu Mar 28 18:48:07 CDT 2024