plsql Questions
4
I know that the show user command return: USER is "SCOTT"
But is it possible in a sql query or in a plsql script to only get the username of the current user and store it in a variable?
13
Solved
I need execute an SQL query in ORACLE it takes a certain amount of time.
So I wrote this function:
CREATE OR REPLACE FUNCTION MYSCHEMA.TEST_SLEEP
(
TIME_ IN NUMBER
)
RETURN INTEGER IS
BEGIN
DBM...
5
Solved
Here is:
declare
v_str1 varchar2(80);
begin
v_str1 := 'test';
print :v_str1;
end
When I run it using SQLDeveloper just in a sql worksheet I get this:
Bind Variable "v_str1" is NOT DECLARED
a...
13
Solved
I'm writing a stored procedure that needs to have a lot of conditioning in it. With the general knowledge from C#.NET coding that exceptions can hurt performance, I've always avoided using them in ...
4
I try very lot options to run in room changeSet/sqlFile which contains pl/sql block and simlple sql statement. E.g.:
BEGIN
aud.someProcedure('parameter');
END;
/
insert into test_table(_id, value...
5
Solved
I have a sample code where i'm trying to print Boolean value.
It resulted error.
wrong number or types of arguments in call to 'PUT_LINE'
wrong number or types of arguments in call to 'TO_CH...
6
I am on Oracle 10g. In a requirement I need to increase the size of a pl/sql VARCHAR2 variable. It is already at 4000 size. I have read that
in PL/SQL, VARCHAR2 can be up to 32767 bytes. For SQ...
3
Solved
I understand that Oracle supports multiple character sets, but how can determine if the current 11g system where I work has that functionality enabled?
8
I'm trying to use a procedure (no parameters) to drop all of the user-created database objects located within the schema from where the procedure is launched, but I'm really not sure on how to go a...
Willtrude asked 9/5, 2009 at 2:19
7
Solved
I'd like to create an in-memory array variable that can be used in my PL/SQL code. I can't find any collections in Oracle PL/SQL that uses pure memory, they all seem to be associated with tables. I...
8
Solved
I am trying to execute some oracle pl/sql procedure with in and out parameters from # code on asp.net. I want to retrive the value from out parameter. but when I execute i am getting a oracle excep...
29
Solved
In SQL I (sadly) often have to use "LIKE" conditions due to databases that violate nearly every rule of normalization. I can't change that right now. But that's irrelevant to the question.
Further...
Karisakarissa asked 10/6, 2010 at 13:44
14
Using the DUAL table, how can I get a list of numbers from 1 to 100?
3
Solved
I'm trying to pass an array of (varchar) data into an Oracle procedure. The Oracle procedure would be either called from SQL*Plus or from another PL/SQL procedure like so:
BEGIN
pr_perform_task('...
Aristophanes asked 21/5, 2010 at 21:5
5
I created below simple block but getting
ORA 06533:Subscript beyond count
error.
Can someone please tell me what I am missing in below code.
declare
type salaryvarray is varray(6) of custo...
5
String s1 = PasswordText4.getText();
String s2 = ConfirmText4.getText();
String s3 = NameText4.getText();
String s4 = UsernameText4.getText();
String s5 = jLabel16.getText();
if (PasswordTex...
Gibbosity asked 6/4, 2016 at 9:40
2
Solved
Im using PL/SQL. I am trying to have a for loop right after I define my temporary tables in the with clause. However, Im getting an error to have a SELECT query first.
For instance
WITH TMP1 AS (...
Livonia asked 30/5, 2016 at 4:47
4
Solved
Is there any official method to use ORACLE Dark Mode?
Pitarys asked 22/11, 2021 at 5:53
9
Solved
When executing the following code, it just says the procedure is completed and doesn't print the infomation i want it to (firstName, lastName) and then the other values from the select query in a t...
Consueloconsuetude asked 3/5, 2012 at 15:24
2
Solved
I get keep getting this error I can't figure out what is wrong.
DECLARE
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 11
Here is m...
18
Solved
Is it possible to search every field of every table for a particular value in Oracle?
There are hundreds of tables with thousands of rows in some tables so I know this could take a very long time ...
Coreen asked 16/10, 2008 at 13:14
8
Solved
I started to use Datagrip for my PL/SQL (school) projects that need the use of DBMS_OUTPUT.PUT_LINE. Before this I was using Oracle SQL developer and I was able to use DBMS_OUTPUT by adding the fol...
Warble asked 2/4, 2018 at 7:13
3
Solved
Say I have a program that searches a database for columns to modify, as part of a database conversion process.
If I attempt to alter a column with a functional index defined gives the following er...
Syllogism asked 14/12, 2009 at 21:18
3
Solved
I have a stored procedure which is being called from a dbms job. i.e.
DBMS_SCHEDULER.RUN_JOB ('Procedure_JB', FALSE);
A java code stored procedure, which after doing some stuff, kicks off Proce...
Grind asked 7/2, 2012 at 16:18
3
Solved
I have a function in postgreSQL,One of my function argument is text type variable and that enclosed with in double quotes so i want to insert this variable to table with out double quotes ,when i s...
Chevron asked 19/9, 2019 at 4:27
1 Next >
© 2022 - 2024 — McMap. All rights reserved.