The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
30 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
23 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
18 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
88 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
61 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 ...