Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: redbadgers
  • Content: Threads
  • Order by date
  1. redbadgers

    PUBLIC SYNONYM value updated but not the mapped physical table

    Hi!! I may have a server configuration issue here since it only happened to one of our Oracle 11.1.0.7 Servers but not the other Servers at the exact same level. We use PUBLIC SYNONYM to update table data. On this particular Oracle 11.1.0.7 Server, the UPDATE operation was successful and we...
  2. redbadgers

    Line limit of AIX messages files

    Hi! When we logged error messages to syslog utility, we found our 3K message got truncated to less than 1K in AIX's messages files. AIX is 5.3 at TL-07. I could not find any document online about the line limit or message limit in the AIX messages files. Is there a configuration parameter...
  3. redbadgers

    DROP PUBLIC SYNONYM inside of stored procedure

    I have a stored procedure that accepts object type and object name as inputs then generates a DROP statement and exec immediate as dynamic SQL. It works fine for all object types except PUBLIC SYNONYM. When user with DBA role (such as "SYSTEM")invokes this procedure to drop a PUBLIC SYNONYM foo...
  4. redbadgers

    Levels of nested table expression allowed

    I used to have a dynamic query within a SQL Procedure that used three levels of nested table expression: SELECT C.col1, C.col2 FROM ( SELECT B.col1, B.col2 FROM ( SELECT A.col1, A.col2 FROM ( SELECT ... FROM xxx ORDER BY... ) A ORDER BY... ) B ORDER BY... ) C...

Part and Inventory Search

Back
Top