Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


PLS-00204: function or pseudo-column 'string' may be used
inside a SQL statement only



PLS-00204: function or pseudo-column 'string' may be used inside a SQL statement only..

Answer / guest

Cause: A pseudocolumn or proscribed function was used in a
procedural statement. The SQL pseudocolumns (CURRVAL, LEVEL,
NEXTVAL, ROWID, ROWNUM) can be used only in SQL statements.
Likewise, certain functions such as DECODE, DUMP, and VSIZE
and the SQL group functions (AVG, MIN, MAX, COUNT, SUM,
STDDEV, VARIANCE) can be used only in SQL statements.

Action: Remove the pseudocolumn reference or function call
from the procedural statement. Or, replace the procedural
statement with a SELECT INTO statement; for example, replace
bonus := DECODE(rating, 1, 5000, 2, 2500, ...); with the
following statement: SELECT DECODE(rating, 1, 5000, 2, 2500,
...) INTO bonus FROM dual;

Please add more information about this Error

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29808: specified primary operator binding does not exist

1 Answers  


PLS-00506: User Defined Constrained Subtypes are disallowed

1 Answers  


ORA-16034: FROM parameter is incompatible with MANAGED recovery

1 Answers  


ORA-30558: internal error [string] in function based index

1 Answers  


ORA-00348: single-process redo failure. Must abort instance

1 Answers  


PLS-00920: parameter plsql_native_library_dir is not set

1 Answers  


ORA-28602: statement not permitted on tables containing bitmap indexes

1 Answers  


ORA-19723: Cannot recreate plugged in read-only datafile string

1 Answers  


TNS-01153: Failed to process string: string

1 Answers  


ORA-01973: Missing change number

1 Answers  


ORA-13228: spatial index create failed due to invalid type

1 Answers  


ORA-09942: Write of ORACLE password file header failed.

1 Answers  


Categories