Questions tagged [oracle]
Oracle Database, developed by Oracle Corporation, is a versatile Multi-Model Database Management System. Please refrain from using this tag for other Oracle-owned products like Java and MySQL.
Is there a built-in functionality in Oracle that allows for storing rich text? I have added HTML tags to formatted text and want to know the correct way of saving it in the database. Upon fetching the stored text in a resultset, I am converting it to JSON ...
I have successfully displayed a PDF file from my database as a blob using the header("Content-type:application/pdf") method. Now, I am looking to also display some additional string results along with this PDF file. Is it feasible to achieve this while d ...
I have a database table with JSON data that I need to decode and store in a relational database. The table is for an Oracle DB 19.0 and it looks like this: CREATE TABLE J_PAGE ( PK_PAGE_ID NUMBER ( 10 , 0 ) , FK_RESP_ID NUMBER ( 10 ...
I have created an interactive report with a form where the interactive report is on page 2 as the parent page and the form page is on page 3 as the child page. In the parent page, I have written JavaScript to open a modal window (form page - page 3) using ...
Currently struggling with sending lengthy strings to Oracle stored procedure RAW variable, encountering the following error: oci_execute(): ORA-06502: PL/SQL: numeric or value error In need of assistance on converting a String to Raw datatype. ...
I am facing a challenge with a dataframe containing 4 million rows and 53 columns. My goal is to write this dataframe to an oracle table using Python. Below is a snippet of the code I have been working on: import pandas as pd import cx_Oracle conn = (---- ...
I have encountered some challenges while handling multiple database calls, especially when dealing with large datasets. It seems that PHP restricts the execution of only one database call at a time per session. This limitation is typically not problematic ...
Setting: My current setup involves using Oracle 19c database with PLSQL JSON functions like JSON_TABLE. The Task at Hand: My goal is to extract JSON data from a CLOB column within a table that contains multiple rows. Dilemma: I have encountered an issue ...
Can someone assist me with inserting multiple rows using a variable in an Oracle database through PHP? Here is my query: $qry6= "INSERT INTO sample(name , id , qty , PRICE , tax) VALUES ".$result_product1.";"; where $result_product1 = (shirt,1,20,300,1 ...
Is there a way to gracefully stop koajs like I've seen for expressjs? I also need to disconnect database connections during the process. Specifically, I have a mongoose database connection and 2 oracle db connections (https://github.com/oracle/node- ...
Currently, I am working on testing the connectivity to our Oracle databases. Recently, I came across node-oracledb, a tool released by Oracle that aims to simplify this process. However, one major hurdle is the requirement of having the Oracle Instant Clie ...
After countless searches on Google, I have yet to find a straightforward solution for my specific scenario. Within an Oracle 12C database, I have a json column (technically a varchar with a json constraint) where I store a map representation like the follo ...
I am currently working on a project to create a dynamic progress bar based on numeric values stored in a database. The database has two fields, 'NEXT_STEP' and 'MAX_STEPS'. When the value of NEXT_STEP reaches MAX_STEPS + 1, it indicates ...
While executing the code below on Oracle 12c : DECLARE l_json clob; l_var varchar2(90); l_query clob; mypath clob; l_path_value varchar2(100); BEGIN SELECT json_column into l_json from my_table; SELECT path_colum ...
I am facing a challenge with printing my page that contains two interactive reports. To enable printing, I have utilized a JavaScript function that triggers window.print(). I have incorporated CSS to adjust the layout of my tables when printed. @media pr ...
I'm in the process of creating a Python script to update a table in Oracle. I've already granted all necessary permissions to the role, and have assigned the role to the schema that I am using for CRUD operations. Interestingly, when I execute database tr ...
Currently, I am working on a project that involves using Alfresco. One of the new requirements for this project is to retrieve a sequence number from our Oracle database and populate a custom property within an Alfresco space. var conObj = new ActiveXObje ...
I've created a Node/Express.js application that connects to Oracle using the node-oracledb module. My challenge lies in returning multiple queries to my view. Most examples I found within the Node-Oracle project are geared towards single queries only ...
I am currently working on a form in Apex 4.1 where I have an address lookup field that utilizes JavaScript to connect to an address database and populate separate fields with the address details (address1, address2, town, postcode). On the same page, I ha ...
Programming Languages: // JavaScript code snippet //https://www.npmjs.com/package/utf8 //https://github.com/mathiasbynens/quoted-printable par_comment_qoted = quotedPrintable.encode(utf8.encode('test ąčęė')); console.log('par_comment_qot ...
I have noticed that when sending an insert query to my Oracle database through MVC ACTION, the insert method seems to be called twice and records the same data twice... Furthermore, when using the same structure to run a select query, I am getting the sam ...
My team at work is responsible for supplying files to other services. These files typically range in size from 5MB to 500MB. We are considering using JSON instead of XML, but I am concerned about how our customers will be able to upload these files into th ...
Currently, I am in the process of establishing a connection to an Oracle database within my Electron application. Can anyone suggest potential solutions or alternative approaches that could be useful in this scenario? ...
I am currently utilizing Npm Oracle in my Node.js application. I am facing an issue where my compiler hangs while trying to connect to the Oracle database, causing a thread to get stuck. I need to implement a timeout mechanism as my client cannot wait for ...
I am working with a NodeJS stream that generates an array of objects, the size of which varies dynamically based on the input. The maximum size of the array is 256. I am looking for a way to avoid inserting each record into Oracle DB individually. Is the ...
I have created a Python application via cPanel and configured the database to connect with Oracle DB on AWS. The application runs perfectly on localhost, but when hosted, I encountered an error stating that the Oracle Client library is missing: Oracle Cli ...
I am currently facing an issue with retrieving a jpg file from an oracle db and trying to display it using the echo command. The jpg file is stored as a blob inside the database and shows up correctly when accessed directly from the database. Below is the ...
Our API is sending us Json payload, for example: { "customerName": "علي الدويش", "customerCode": "999999", "shipAddress1": "البلاغة", } To store this data, we are utilizing Sprin ...
Is there a way to dynamically enable or disable a button based on the result of a database query in JavaScript? I have managed to display an error message (with id="error") depending on the result, but toggling the button (with id="generate") doesn't seem ...
Looking for a way to insert an image into an Oracle database using OCI with PHP, Ajax, and jQuery. I've searched online but couldn't find any examples. If anyone has a solution, please share. Thanks in advance. <label for= ...
Every time I try to upload an image in the product option, Magento 1.9.0.1 gives me an error saying "Disallowed file format." ...
For integration testing, I am looking to test some connections between a web application and its Oracle DB data store. There is a specific table where I want to verify the stored values. I am contemplating the most effective method to accomplish this task ...
Hey there, I have a question regarding resultSet processing in my query. The query runs smoothly until I add 'ORDER BY name des', resulting in an ORA-00933: SQL command not properly ended error. This is the current query I am using: router.post('/report/ ...
Using node.js, oracle, and the oracledb module, I have a simple PL/SQL procedure as shown below: procedure mock_lobs( P_CLOB IN OUT CLOB, P_BLOB IN OUT BLOB ) AS BEGIN NULL; END mock_lobs; This procedure return ...
I am currently using oracledb (4.0.1) in conjunction with node (v10.14.2). The JSON list shown below is what I have: [ { DIFFID: 8, DIFFDATE: 2019-11-01T14:04:41.831Z, REGIONNAMEA: 'TURKEY', VENDORA: 'XXX', SOURCECOUNT: 797, DIFFCOUNT: ...
My query generates the following output: { key:1,label:"R. Bulan"} { key:2,label:"R. Bintang"} { key:3,label:"R. Akasia"} { key:4,label:"R. Guest Room"} This is my SQL query: select '{ '||'key:'||IDMEETINGROOM||''||',label:"'||NAMARUANG||'"'||'} ' json ...