• Running Procedures within the PL/SQL program

    WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!

    Nimsalwayz5 pointsBadges:
  • Truncate or not Truncate SQL

    What are the pros/cons of truncate a table export/import to just drop table?

    Jay Dog5 pointsBadges:
  • HOw to Find Duplicate Geometry in Oracle Spatial

    If anyone knows a SQL statement for Oracle spatial on how to find duplicate geometry for area, line and point features, I would much appreciate it if she\he can share this with me. A million thanks in advance... Regards, Sam

    SamAvella30 pointsBadges:
  • insert and updat remote table

    am using a trigger to sync a remote table every time there is an update or insert on the local table. The columns are user-type object. The tirgger can not insert or update on the remote table. I get the following error: CUSTOMERS Table : ORA-22804: remote operations not permitted on object tables...

    T-REX5 pointsBadges:
  • Oracle table column names starting with a number

    Hello, I just finished creating MANY tables that have column names starting with a number. I didn’t realize it was an issue until I started trying to select data from my tables using the column names in the where clause. Inserts work. Selects without where work. Is there any way to keep the...

    Jaime0 pointsBadges:
  • How to capture error stack when using forall in PL/SQL?

    How do you capture all the errors in an error stack when using forall/bulk processing within PL/SQL? This is the error stack: ORA-12801: error signaled in parallel query server P000 ORA-01722: invalid number The only error captured in PL/SQL is the first error message but the second is actually...

    Rb plsql0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following