plsql Questions
6
Does dbms_output.put_line decrease the performance in plsql code?
Mackmackay asked 7/2, 2011 at 8:56
3
This is a follow on question to Vincent Malgrat's answer to this question. I can't find the correct syntax to use when you need to use the same bind variable multiple times when using OPEN...FOR dy...
Olethea asked 4/3, 2020 at 16:23
3
Solved
How can I do in one select with multiple columns and put each column in a variable?
Something like this:
--code here
V_DATE1 T1.DATE1%TYPE;
V_DATE2 T1.DATE2%TYPE;
V_DATE3 T1.DATE3%TYPE;
SELECT T...
Grillo asked 7/8, 2013 at 16:55
7
Solved
I am using oracle 10g express edition. It has a nice ui for db developers. But i am facing some problems executing stored procedures.
Procedure:
create or replace procedure temp_proc is
begin
D...
11
Solved
I am doing a project creating an admission system for a college; the technologies are Java and Oracle.
In one of the tables, pre-generated serial numbers are stored. Later, against those serial n...
Thermomotor asked 10/6, 2012 at 12:1
3
Solved
When I create the following procedure
create or replace procedure check_exec_imm(
tab IN VARCHAR2,
col IN VARCHAR2,
col_name IN VARCHAR2
)
IS
cv SYS_REFCURSOR;
col_value VARCHAR2(32767);
lv_...
2
Solved
Ora-01086 : save point was not established or invalid.
KRD_UPD_BORCTAHSILATYAP_SP this SP throws errors .
When I test this loop below, I get the error: ora-01086
Normally it works without calling...
Liven asked 15/1, 2014 at 13:23
1
We have logging tables in our Oracle database that show old and new values when changes are made to certain data fields. One of these fields is a SQL_TEXT field (for running reports via dynamic SQL...
Sunflower asked 26/1, 2022 at 3:35
6
Solved
I am running the following script -
BEGIN
select department_name
from egpl_department
where department_id in (select department_id
from egpl_casemgmt_activity);
END ;
And got the Error -...
0
I'm currently using
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
PL/SQL Release 12.1.0.2.0
The following doesn't work for me ...
-- Since PL/SQL 20.2.0.175
DEFINE usr = 'YourName';
SEL...
2
Solved
I was checking this, but not find the proper one. So I prepared one and sharing that query here.
Haemal asked 8/6, 2020 at 8:22
9
We get sometimes the following error from our partner's database:
<i>ORA-01438: value larger than specified precision allows for this column</i>
The full response looks like the foll...
1
Upgrading from 6i to Oracle 11g Fusion Middleware. How can a record group be passed from a form to the report? We were using DATA_PARAMETER but I understand that that is no longer an option.
Duckworth asked 23/4, 2015 at 14:39
2
Solved
I need to do truncate table and then insert data in that table using procedure.
However, one does like dinamic sql but the other one doesn't:
create or replace
procedure RECREATE_AGGREGATE
AUTHI...
2
We have switched to new Microsoft ADFS server and now we have to use LDAPS (LDAP over SSL on port 636). However in PL/SQL packages by adding DBMS_LDAP.open_ssl (based on here ) I get :
ORA-31202: ...
Cantillate asked 8/9, 2016 at 0:56
2
Solved
I'm looking to create a package, already have a working procedure. Working on a function, step by step and I have encountered an
ORA-06575: Package or function PROJECT_LENGTH is in an invalid stat...
Overall asked 3/1, 2019 at 17:12
5
Solved
I have a SQL script that is being executed in TOAD. Currently, I have it laid out with just statement after statement, thusly:
select such-and-such from somewhere;
delete other-thing from somewhe...
3
I want to send an UTF8 json string via utl_http to a node.js Server via POST. Sending the string
["Sant Julià de Lòria"]
does arrive as
["Sant Juli� de L�ria"]
The PL/SQL code goes like:
...
1
Solved
i have a table with 12 columns:
table1:
1
2
3
4
5
6
7
8
9
10
11
12
abc
1
000
aaa
zzz
2
234
OOO
00001
01
123
214
def
2
023
bbb
yyy
4
345
PPP
00002
02
133
224
ghi
3
011
ccc
xxx
6
456
QQQ
...
Harrie asked 4/11, 2021 at 4:4
2
Solved
I'm debugging an Oracle package using PL/SQL developer, but I'm running into a problem - one of the parameters is a CLOB (it's a big ass XML string). I can pass it in from the application side and ...
Sidra asked 29/10, 2011 at 17:9
12
Solved
I would like to find the number of rows in a cursor. Is there a keyword that can help? Using COUNT, we have to write a query. Any help will be greatly appreciated.
Tidewaiter asked 8/2, 2011 at 14:17
10
Solved
I have a workqueue table that has a workid column. The workID column has values that increment automatically. Is there a way I can run a query in the backend to insert a new row and have the workID...
5
Solved
I need to combine columns with select statment such that it create a tab delimited file.
For. e.g
Select ColumnA || "," || ColumnB
Above statement will create Comma Seperate File. What should I...
Magnetic asked 8/11, 2011 at 6:45
3
Solved
Does anyone know whether it's possible for a PL/SQL procedure (an error-logging one in this case) to get the name of the function/procedure which called it?
Obviously I could pass the name in as a...
2
Solved
This question and related answers will be for educational or learning purpose only.
This question is much different from my other post and is not duplicate. Since it was creating confusion and as s...
Eudiometer asked 4/10, 2021 at 19:41
© 2022 - 2024 — McMap. All rights reserved.