147 questions
0
votes
1
answer
55
views
setting a datetime into global application item
Oracle APEX 24.1
I have 3 application items.
I have this procedure
procedure set_globals is
begin
apex_debug.message(p_message => 'Setting system globals');
apex_util....
- 519
2
votes
1
answer
493
views
How to resolve error "ORA-00911: invalid character" in Golang?
I am facing error "ORA-00911: invalid character" while invoking below function. If I use SQL query with hardcoded values (as of now it is commented out in below code snippet) then I am ...
- 423
1
vote
3
answers
1k
views
Difference Between "&" and "&&" in oracle
I'm studying the differences between bind variables(:) and ampersand operator(& / substitution variables).
I realized that "double ampersand is stored variable values and reused these values ...
- 13
0
votes
1
answer
280
views
Is it possible to create bind variables without a colon?
I generated this code via CHATGPT to better understand Bind variables in Oracle SQL:
DECLARE
v_employee_id NUMBER := 1001;
v_employee_name VARCHAR2(50);
v_salary NUMBER;
BEGIN
-- SQL statement ...
1
vote
0
answers
452
views
How to use loop variables as bind variables Snowflake?
I want to use the row_variable from a for loop as a bind variable,
FOR <row_variable> IN <cursor_name> DO
statement;
[ statement; ... ]
END FOR [ <label> ] ;
DECLARE
...
- 23
0
votes
1
answer
226
views
python oracle excute error(ORA-01036: illegal variable name/number) [duplicate]
hi i am korean so not native english speaker
anyway i have question
when i learning sql and python flask connect
this is my code
sql='''select count(*) from member where id = :1 '''
result=curs....
- 1
0
votes
1
answer
500
views
Passing Bind Variable in case statements in Oracle query
I want to pass Bind Variable (a Date) in a Case statement in order to achieve the following:
When User inputs a date and if that Date is falling on Monday, then the Case statement should fetch the ...
0
votes
1
answer
434
views
Is it possible to pass bind variable as parameter?
Is it possible to pass a bind variable to a procedure? Here a simplified snippet, to show what I'm trying to do:
CREATE OR REPLACE PROCEDURE TEST_CSV ( :d1 IN DATE DEFAULT null, :n1 IN NUMBER DEFAULT ...
- 121
0
votes
1
answer
590
views
Error(20,56): PLS-00049: bad bind variable 'NEW.NEW_NAME'
I am facing this error while creating a trigger.
error - Error(20,56): PLS-00049: bad bind variable 'NEW.NEW_NAME'
if anyone can help it will be appreciated.
Please refer to my code below
Thanks in ...
- 3
0
votes
3
answers
2k
views
Pass BOTH single bind variable and list variable to SQL query cx_Oracle Python
I have a Oracle SQL query:
SELECT * from table1 WHERE deliveredDate = ? AND productID IN (?,?,?,...);
I would like to pass a single variable to deliveredDate and a list with length unknown to the ...
- 129
0
votes
2
answers
366
views
How to iterate over binary string in Oracle?
enter image description here
declare
str varchar2(2000) := :inputstr;
v_len number;
currChar CHAR(1);
begin
v_len := length(str);
for i in 1..v_len
...
- 75
0
votes
0
answers
469
views
bind variable substitution in oracle sql string
I am trying to get the default dbf file location from a select statement and use this location to create tablespaces later on. I am having some trouble doing it in the sql script. I tried to use pl/...
- 61
0
votes
0
answers
352
views
Why aren't my bind variables working in APEX 19?
I've been using APEX ever since version 4, and I remember making Classic Reports with queries like "select b, c, d from my_table where a = :P1_A_VALUE"
:P1_A_VALUE might have been created on ...
0
votes
1
answer
67
views
PHP MySQL bind variable not working with REGEXP_INSTR
MySQL version is 10.1.19-MariaDB.
PHP version is 7.0.13.
I have a table called words2:
CREATE TABLE words2 (word varchar(64));
INSERT INTO words2 VALUES ('ABSCESS'), ('ABSCISE'),('ABSCOND'),('ABSENCE')...
- 4,034
0
votes
1
answer
2k
views
How to initialize a value on a bind variable in the oracle apex?
I'm having problems when executing this code in oracle apex:
VARIABLE b_var NUMBER(20);
BEGIN
:b_var := 100;
END;
PRINT b_var;
what I am trying to do is initialize a value to a bind variable ...
- 33