Questions tagged [plsql]

Oracle Corporation developed PL/SQL (Procedural Language/Structured Query Language) as an extension to SQL. When seeking assistance with PL/SQL, it is recommended to use the tag "oracle". For questions related to standard DML or DDL statements, utilizing the tags "sql" and "oracle" is advised instead of "plsql".

Encountering a problem with Oracle 12c when attempting to retrieve a JSON value exceeding 11000 characters using JSON_VALUE

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 ...

sqljsonoracleplsqloracle12c

How can I ensure that null columns are included in the JSON output generated with apex_json?

Within my 19c database, I have multiple stored procedures that utilize the apex_json package to convert cursor results into JSON for a rest API. Recently, I encountered an issue where certain columns I select contain null values. As a result, these column ...

jsonrestplsqlnull

Obtain the value and parameter from a JSON array using PL/JSON

I am seeking a way to retrieve both the value and parameter in a JSON list using the pl/json library. For instance, {TABLE:"TEST",Parameters:[{"PID":"bar"},{"PFOJ":"baz"},{"PCLI":"bar"}]} My goal is to extract the parameter and its corresponding value fr ...

jsonplsqlplsqldeveloperpljson

Instructions on how to insert a single parenthesis into a string using Angular or another JavaScript function

Currently, I am employing Angular JS to handle the creation of a series of SQL test scripts. A JSON file holds various test scenarios, each scenario encompassing a set of projects to be tested: $scope.tests = [ { "Date": "12/31/2017", "Project": ...

javascriptangularjsplsql

Issues with transferring arguments between PHP and PL/SQL

Having ventured into application development with PL/SQL for the first time, I encountered some struggles in passing parameters to PHP PL/SQL. The pre-existing PL/SQL functions within the database seemed to return the expected parameters when executing the ...

phpplsql

Looking to duplicate a row of input fields while maintaining the same validation rules as the original row?

form <form action="assign_web_menu_action.php" method="post" name="form1" id="form1" > <table id='menuAssign'> <tbody> <tr class="clone_row"> <td> <input type="text" name="menuname[]" id="menuname1" onblur="m ...

javascriptphpjquerytwitter-bootstrapplsql

How to retrieve data from a PL/SQL function using cx_Oracle in Python

I need assistance in running an Oracle PL/SQL statement using cx_oracle in Python. Here is the code snippet: db = cx_Oracle.connect(user, pass, dsn_tns) cursor = db.cursor() ... sel = """ DECLARE c NUMBER := 0.2; mn NUMBER := 1.5; res NUMBER; ...

pythonplsqlcx-oracle