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

PLS-00493: invalid reference to a server-side object or function in a local context

1 Answers  


LPX-00274: can't import node type

1 Answers  


TNS-01170: Event detection broke for address: string

1 Answers  


RMAN-06067: RECOVER DATABASE required with a backup or created controlfile

1 Answers  


ORA-32409: materialized view log on "string"."string" already excludes new values

1 Answers  


ORA-06565: cannot execute string from within stored procedure

1 Answers  


QSM-01025: materialized view, string, not found

1 Answers  


LCD-00208: unexpected keyword in value list [string]

1 Answers  


ORA-06533: Subscript beyond count

1 Answers  


ORA-26091: requested direct path operation not supported

1 Answers  


ORA-02825: Request on free list was not free

1 Answers  


ORA-09953: scggc: unexpected return of a lock convert

1 Answers  


Categories