The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
13 views

Stop on error in PL/SQL developer or Oracle SQL Developer

At this time I am using TOAD to apply SQL*Plus scripts and there is an option to stop on the first error. After it I can fix the script and apply the remaining part. Due to license issues we can't ...
0
votes
2answers
40 views

How to detect in which schema a procedure is called?

I'm struggling with a problem in Oracle 12.1 regarding to procedures. We are using a data isolation approach based on schemas. We use one schema as PUBLIC and each project has exactly the same ...
0
votes
1answer
1k views

ora 20001 error in oracle dbms scheduler

i have written a test job like begin DBMS_SCHEDULER.CREATE_JOB ( job_name => 'test_job' ,job_type =>'plsql_block' ,job_action => 'null' ,enabled => true ); end; / after a while when ...
1
vote
1answer
54 views

How can I send an email when objects get invalidated?

I have couple stored procedures and a package. Whenever this stored procedure and package goes invalid, I need to send an email. How can I achieve this? Can you please give me an idea how this ...
1
vote
1answer
511 views

First query running in PL/SQL Developer results the error

When I run first query in PL/SQL Developer I got the error: Dynamic Performance Tables not accessible, Automatic Statistics disabled for this session You can disable statistics in the preference ...
0
votes
0answers
32 views

dynamic query manupulation

I am trying to append a dynamic query given below to a non-dynamic query. Given below is the dynamic query. sqlFilter1 := ' and (g.STSL_USRS_ID = ' || User_ID || 'OR (dept.DEPT_NAME IN (select ...
0
votes
1answer
52 views

Initializing values to a custom data type

I have defined a custom data type which I need to use in my procedure. Give below is my data type. CREATE or REPLACE TYPE CUSTOM_DATATYPE AS object( chkinvpre VARCHAR2(100), orderid ...
0
votes
0answers
71 views

storing multiple values in variable

oracle:11g Hi, I have a query wherein I need to store the result of a select sql query which can return multiple values(I am selecting only one column so the values will be from the same column). ...
-2
votes
1answer
167 views

Stored procedure syntax error [closed]

I am writing a procedure, independently the queries run fine with no errors.. But, when I run it as a procedure I get errors. Given below is my procedure create or replace PROCEDURE xyz(inuserid ...
0
votes
1answer
114 views

PL/SQL Developer - empty object list

I'm using PL/SQL Developer v9, brio intelligence 6.6 and on another computer SQL Developer v7. On version 7 everything is ok. My table objects are 'expanding' shows all avaiable databases. In ...