All Questions
31 questions
0
votes
1
answer
41
views
How to create a function in PL/SQL and return output
I am try to create a function that will table input to function and return me output
My code :
create or replace function details(keyword varchar2 , depid varchar2 )
return clob
AS
v_lst CLOB :=...
- 133
0
votes
1
answer
39
views
Checking of current system date in static table
I am new to pl/sql blocks..i have a requirement inside my proc as below:
I have a static data table tb_calender having column extract_date with DATE type. Want to check if the current system date is ...
- 11
2
votes
4
answers
140
views
Derive function from table in PLSQL
I have created a demo function to add two numbers in PLSQL:
create or replace FUNCTION Addition(
x number,
y number
)
RETURN number
AS
result number;
BEGIN
result := ...
0
votes
3
answers
43
views
Is there any faster way to perform merge on 120k records weekly in oracle pl/sql?
There are around 120k records in the database, and based on a few functions I calculate scores for all the records, weekly I have to update the table with new records and respective scores.
Below is ...
- 87
0
votes
1
answer
244
views
how to call an oracle procedure and a function inside another procedure
I have a situation, where I need to do the following.
Step1: Call a procedure with the given input values and get the 2 output values.
step2: Call the function with input parameters along with one ...
- 91
-1
votes
1
answer
3k
views
PL/SQL Script to create a procedure to calculate and return the area of a triangle
Hello guys i really need some help with oracle procedures and functions, I am a newbie in Oracle RDBMS and I can't seem to get the hang of it. Here is the question:
Define the Oracle PL/SQL script to ...
- 9
-3
votes
2
answers
1k
views
insert into table1 select * from another table2 , then delete the row from table2
I am trying to insert rows into table1 select * from table2 and finally delete the rows from table2 using function in oracle sql developer. I am not getting how to do it.
follwing is my function:
...
1
vote
1
answer
4k
views
ORA-30626: function/procedure parameters of remote object types are not supported
I am new to oracle technology, please help me
I couldn't find the answer any were. My task is to run two function's by passing parameter through dblink. I have two the same function on db1 and db2 ...
- 11
0
votes
0
answers
103
views
Is there a way to improve return time of ref cursor data set?
I have a procedure that builds the where clause of a query based off of the text from a user's input, and a function that concats the query and the where clause and returns a refcursor. This works ...
- 29
0
votes
0
answers
37
views
What considerations Do You have about my PLSQL package?
I had a little doubts about my code but yesterday I finally understood some points about to how to start coding my final package project. I share this code with the purpose if You want suggest me some ...
user6611026
0
votes
2
answers
230
views
oracle declare a user defined type that can be used across multiple functions and procedure
I have an SQL file that creates other stored procedures/functions. I wanted to make use of a user defined type that can be accessed among the created stored procedures/functions. What is the best way ...
1
vote
2
answers
1k
views
SQL Error: ORA-00904: "CNPPARMID": invalid identifier
I have a function:
At line execute immediate 'select ' || schemaname || '.' || value1 || '_seq.nextval from dual' into cnpParmId;
Am getting error as SQL Error: ORA-00904: "CNPPARMID": invalid ...
- 131
-2
votes
1
answer
815
views
sql command not properly ended for select statement
I have a pl/sql function and in that i have the following piece of code:
execute immediate 'select ' || schemaname || '.' || value1 || '_seq.nextval from dual into cnpParmId';
for this line, I am ...
- 131
0
votes
1
answer
731
views
Resetting a variable value for each insert
I have a PL/SQL function as follows:
create FUNCTION Test
return number
IS cnpParmId NUMBER;
good VARCHAR(1) := 'F';
exist VARCHAR(1) := 'F';
begin
good := 'F';
exist := 'F';
loop
select schema1....
- 131
1
vote
2
answers
3k
views
Oracle PL/SQL: Call DML procedure from a function
I have a procedure that has DML commands. the procedure accepts a variable of type out, and it returns a value.
i need call this procedure from a function.
the goal is that the function will return ...
- 7,373