The only difference is that in second query Ive not used outer table at second level.SELECT TMADMIN.pkgtwatchinvdb.MaxTrkDate(tmadmin.sites.studyid,tmadmin.sites.siteid, 1000280)) Qualified Date FROM tmadmin.sites tmadmin is the Schema Name pkgtwatchinvdb is the package name maxtrkdate is a function inside the package (returns date) I am using the same format for other function, it doesnt give any errors.
![]() The code complies successfully but when I am executing the code, here is the error I get. The code works successfully when I manually insert the values (as done in the commented out statement) but when use it from variable, it gives me error. ORA-00904: ENDDATE: invalid identifier ORA-06512: at TESTING.CUBEVIEW, line 18 ORA-06512: at line 6 START DATE IS 90301 END DATE IS 111201 Process exited. ERROR at line 1: ORA-00904: DBMSMETADAGE.GETDDL: invalid identifier run catproc.sql to create plsql package But the error still occurs. EXP-00008: ORACLE error 904 encountered ORA-00904: POLTYP: invalid identifier EXP-00000: Export terminated unsuccessfully The export tool I used is of Release 10.2.0.4.0. But on my previous oracle 10gr2 server I enabled the auditing. After doing successful upgrade now when I try to login with any user except sys I receive the following error: SQL conn scotttiger ERROR: ORA-00604: error occurred at recursive SQL level 1 ORA-00904: OBJEDITION: invalid identifier ORA-02002: error while writing to audit trail ORA-00604: error occurred at recursive SQL level 1 ORA-00904: OBJEDITION: invalid identifier I got the workaround by setting the parameter audittrailFALSE (Previous value was DBEXTENDED).But I want my auditing to be enabled as per y requirements. To sum up the procedure in one line it dynamically forms a string to get the values of the type which is passed as an input to the procedure. But when I execute the select statement which is nothing but the value in vtypedata directly (as seen in the comments in the code below) there is no error. But when the same vtypedata is used in execute immediate, I get an error. CREATE OR REPLACE procedure execimm(ptypedata execimmt) AS vtypestr CLOB: NULL; vtypedata CLOB: NULL; vtypename VARCHAR2(25): NULL; BEGIN code. However, when another user run the report, it get the the following error. Terminated with error: REP-300: GETNSCLTOT: invalid identifier tochar (getNSCLTot(NFL,todate(:periodenddate,DD-MON-RRRR),1),999999.99),col2. Obviously, I am updating it to a constant. OK, duh. Of course it works, its easy. Ora-00904: Datediff : Invalid Identifier Update It ToNow, I really need to update it to a value in another table that is in my cursor. I believe that I probably need to declare a secondary cursor. Im just getting back in the DBA saddle, so Im a little rusty. BEGIN FOR updrec IN updrecordcur LOOP update toad.fswcmas sw set sw.swcmcycle toad.ttp43425load.newcycle WHERE rowid updrec.rowid; total: total 1. Error starting at line 1 in command: INSERT INTO driver (registration, make, model, gvw, year) VALUES(4585 AW,ALBION,RIEVER,20321,1963) Error at Command Line:1 Column:53 Error report: SQL Error: ORA-00904: YEAR: invalid identifier 00904. Im getting errors. The error message I am receiving is: ORA-00904: Department.UIWKLYEARNS: invalid identifier. ORA-00904: JAN: invalid identifierORA-06512: at LWNER.SHYCREATEMAPING, line 184ORA-06512: at line 2 when displaying with using DBMSOUTPUT DBMSOUTPUT.PUTLINE(Cstartdatetype(i)Cstartdatetype(i))); Its diaplaying it as 01-JAN-70. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |