All Questions
8 questions
0
votes
1
answer
43
views
Stored Procedure With Function giving me errors in Oracle
I have stored procedure and function and I am calling the function in the stored procedure in ORACLE.The function CalculateIncomeTax is what is giving me errors.In MSSQL,this type of update is ...
- 474
1
vote
3
answers
2k
views
Oracle procedure updating all records
Hi am trying to update specific records from table using stored procedure in Oracle,
but its updating all records instead of specific records.
Here is my EMP table before executing stored procedure
...
- 83
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
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 ...
0
votes
1
answer
484
views
Returning Nothing in Oracle Function
I created function in oracle and I've noticed that its returning nothing/empty string.
Oracle Function
CREATE OR REPLACE function UDF_GET_STATUS(P_ID in NUMBER)
return NVARCHAR2 is
l_status ...
- 27
0
votes
1
answer
711
views
Oracle 11g: union all with dbms_random
I'm trying to write sql statement in oracle 11g that will randomly select 5000 records from union of two different tables with same columns:
select *
from (
select ename, job
from ...
- 49
1
vote
1
answer
274
views
Oracle SQL: Count and sum in e.g. 4 hours?
I have one follow up question on an already solved Q (Oracle SQL: Counting in 4h?).
If there is another column in data sample presented, amount column, and I want to do all the same as it is proposed ...
- 49