Recent content by themikeaustin

  1. T

    Debugger not functioning in 10g?

    Thanks! I was afraid of that...
  2. T

    Debugger not functioning in 10g?

    I am running the following configuration: PL/SQL Dev: 4.0.3.416 OCI: 8.1 DLL: \oracle\ora8i\bin\oci.dll Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 When I try to invoke the debugger, I receive an error that "the debugger requires oracle version 7.3.x or higher" What do I have to...
  3. T

    ORA-03291: Invalid truncate option - missing STORAGE keyword

    Thanks. I was afraid of that. I scanned the user guide, but couldn't find anything definitive.
  4. T

    ORA-03291: Invalid truncate option - missing STORAGE keyword

    All, I receive the above message when I attempt to execute the following statements from within a SQL Window: TRUNCATE TABLE dmart_test.Enrollment_tmp DROP STORAGE INSERT INTO Enrollment_tmp (EnrollmentID, ElectionCode) SELECT e.EnrollmentID, se.ElectionCode FROM finance_ml_qa.Enrollment e...
  5. T

    Excecute Immediate error

    Thanks! That works for me!
  6. T

    Excecute Immediate error

    All, When I try to run this code from within PL/SQL Developer, I receive an "ORA-00900 Invalid SQL Statement". When I remove the string delimiters and concatenation text, the create table statement runs fine in SQL*Plus. EXECUTE IMMEDIATE 'CREATE GLOBAL TEMPORARY TABLE BasicInfo ( ' ||...
  7. T

    ORA-00904 invalid column name

    I am having the same problem. Here is my query: SELECT c.rowid, c.*, l.PrimaryContact FROM I_SiteContact c, I_SiteContactSiteLink l WHERE l.SiteID = :SiteID AND c.SiteContactID = l.SiteContactID ORDER BY c.LastName Is this dataset not updateable because it has a column from a...
See more
Back
Top