ORA-00904 Questions

1

Getting the error unable to perform query ora 00904 on an item of previous form which is already deleted.
using oracle 6i i save as a form to make another one and deleted all the items,triggers and other programme units,lovs from it. I added new items and new data source to its block. But its giving the error unable to perform query ora 00904 on an item of previous form which is already deleted. [...]

Answer Question   |  July 1, 2010  11:58 AM
ORA-00904, Oracle 6i, Oracle Error Codes, Oracle Forms 6i, Oracle Query
asked by:
10 pts.

Invalid objects after upgrade from 8.1.7.4 to 10G
for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; EXCEPTION WHEN OTHERS THEN Vrc2_err_msg:=SUBSTR(SQLERRM,1,200); RETURN; END GET_ALL_REGIONS; I am getting this error. pls-00321: expression ‘R_REGION_LIST’ is inappropriate as the left hand side of an assignment statement PL/SQL: [...]

Answer Question   |  March 30, 2009  8:39 PM
ORA-00904, Oracle 10g, Oracle error messages, Oracle upgrades, PL/SQL, PLS-00321, SQL
asked by:
5 pts.

Updating Microsoft SQL Server tables from Oracle generates error
i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: “NAME”: invalid identifier.

Answer Question   |  October 22, 2008  8:58 AM
Microsoft SQL Server 2000, ORA-00904, Oracle error messages, Oracle import/export, SQL Server 2000, SQL Server import/export
asked by:
10 pts.

What causes ora-00904 error on valid fields when querying across dblink in a cursor
I have a procedure that contains a cursor that runs in a cursor for loop. The select query runs fine over the dblink all by itself, but when I try to compile the procedure, I get the PL/SQL: ORA-00904: invalid identifier on the column names. I can do a describe on the table over the [...]

Answer Question   |  June 20, 2008  11:18 PM
Cursor, DBLink, ORA-00904, PL/SQL
asked by:
15 pts.

1