29,196 questions
Advice
1
vote
4
replies
66
views
Check valid identifier name in Oracle
The database tool in IntelliJ can detect if an identifier needs to be quoted to make a statement work.
If I use a valid table name, the quotes are removed.
How can I do the same?
The best would be a ...
- 1,253
1
vote
1
answer
43
views
Render page item which has HTML in Oracle Apex
I have an application where I need to display and stylize the heading of the region. So instead of display heading simply as "Car", I need to display "car icon Car". This icon and ...
- 609
0
votes
1
answer
84
views
Error when calling dbms_cloud.export_data
I'm trying to do my first CSV export into an existing AWS S3 bucket. Calling with type CSV:
call dbms_cloud.export_data(credential_name => 'cred', file_uri_list => 'https://s3.us-east-2....
- 1
0
votes
1
answer
58
views
Oracle sql. how to check file existence on remote server
I'm trying to check if a file exists on a remote server, in a Forms 12c program unit.
I tried to use
utl_file.file_exists('\\server\d$\folder\filename.txt')
and also
utl_file.fgetattr('DBFOLDER','...
- 23
1
vote
2
answers
64
views
XML in Oracle PL/SQL - How to read a big hexBinary node?
I have an XML file with a node containing a file that has been converted into hexbinary.
The ultimate goal is to read that node, convert it back to an actual file and store the path of that file in a ...
1
vote
1
answer
93
views
New oracle apex plugin firing on page load/initialization
I have creating my first simple plugin. The idea is to have button in a page, on clicking of which an interactive report region will be reset, instead of going through "Actions menu" of IR.
...
- 609
0
votes
2
answers
92
views
How to SELECT inside a DECLARE block? [duplicate]
Context:
As a developer in a large company, I am allowed to query (read-only) any table in the database and see the result (for debugging and investigation purposes).
When I do so (either from ...
- 1,794
Best practices
0
votes
3
replies
46
views
How to apply value for a date series based on effective date in postgres
I have these two tables. Table 1 has item and the bucket it's supposed be in and the ratio and the effective date/start date. Table two has the value of the items for a date series. I want to join the ...
- 955
0
votes
1
answer
64
views
Where to define nested procedures in case when I need - variables + cursors + nested procedures?
I need to add 2 nested procedures into huge existing stored procedure.
But all my attempts fail with different errors.
Unfortunately, I cannot find in Oracle documentation - what is correct sequence ...
- 459
0
votes
1
answer
67
views
Reset APEX User Password [closed]
I am trying to reset the password for my APEX user account. I tried executing and committing the following update:
UPDATE wwv_flow_fnd_user
SET account_locked = 'N' , web_password = 'newpass',
...
- 1,461
1
vote
2
answers
99
views
Issue with compiling PL/SQL: invalid relational operator
Environment Oracle 19c (also 12c)
Here's my code:
CREATE OR REPLACE TRIGGER ClientTime
AFTER INSERT OR UPDATE OR DELETE ON ClientTime
FOR EACH ROW
DECLARE
v_pk_json CLOB;
v_changed CLOB;
...
- 6,191
0
votes
1
answer
47
views
Failed to write to, flush, or close a file. in PL/SQL while trying to write csv file using UTL_FILE
I am trying to create a CSV file of college courses for the current term from a Banner DB (Oracle) using PL/SQL. I’ve created lots of scripts to do this…and no had this issue before.
I’ve spent over ...
- 41
0
votes
0
answers
31
views
Different results when invoking function with raw sql and plsql [duplicate]
Well I have 2 distinct Oracle 12c databases, lets name them db1 and db2
I have a link from db1 to db2 (DBL_DB2), also grants for execution of pkg2 which contains procedure 2, which we call proc2 (in ...
2
votes
3
answers
93
views
Remove empty params from URL
URL like this
https://test.com/test?username=john&x1=1234&x2=5677
I want to remove params if any of them looks like param=.
So for example:
https://test.com/test?username=&x1=1234&x2=...
- 702
0
votes
1
answer
94
views
Unable to pass TO_TIMESTMAP and use filter condition in query oracle
DECLARE
v_sql_stmt VARCHAR2(2000);
v_INSERT_DATETIME TIMESTAMP(6);
BEGIN
SELECT
MAX(INSERT_DATETIME)
INTO V_INSERT_DATETIME
FROM
LOG_TABLE;
v_sql_stmt := '...
- 524