Oracle PL/SQL procedure – To return CLOB variable with XML data as OUT parameter

Advertisements I have the following data in XML format <OutputParameters xmlns=http://xmlns.oracle.com/cloud/adapter/ xmlns:xsi=http://www.test.org/1998/XMLSchema-instance> <Header> <Header_item> <TRANSACTION_NUMBER>YSCPQ_9876</SOURCE_TRANSACTION_NUMBER> <TRANSACTION_SYSTEM>OPS</SOURCE_TRANSACTION_SYSTEM> <Lines> <lines_item> <TRANSACTION_ID>YSCPQ_9876</SOURCE_TRANSACTION_ID> <TRANSACTION_LINEID>1</SOURCE_TRANSACTION_LINEID> </lines_item> <lines_item> <TRANSACTION_ID>YSCPQ_9876</SOURCE_TRANSACTION_ID> <TRANSACTION_LINEID>2</SOURCE_TRANSACTION_LINEID> </lines_item> </Lines> </Header_item> </Header> </OutputParameters> I need a procedure to store this XML output in a CLOB variable and return it as OUT parameter. Any help would be much appreciated. >Solution… Read More Oracle PL/SQL procedure – To return CLOB variable with XML data as OUT parameter

May 3, 2023 MRLeave a comment

MS SQL How to field add auto increment dependent on another field

Advertisements For example, there is a table int type int number int value How to make that when inserting a value into a table indexing started from 1 for different types. type 1 => number 1,2,3… type 2 => number 1,2,3… That is, it will look like this. type number value 1 1 – 1… Read More MS SQL How to field add auto increment dependent on another field

January 16, 2023 MRLeave a comment

Add a generated comment in select statement of mysql

Advertisements I know it is possible to add comments to select statements as follows: select /*my comment*/ id, name from myTable; But is it possible to make this comment more flexible and dynamic? for example, I want to add the bellow variable as a comment in a select statement in a procedure. set @mytext =… Read More Add a generated comment in select statement of mysql

January 11, 2023 MRLeave a comment

Error en begin al querer crear un package con procedimiento

Advertisements lo que pasa es que estoy tratando de hacer un package en oracle, pero me sale un error en el begin al momento de crear el procedimiento, he investigado el error que me sale el cual es: PLS-00103: Se ha encontrado el símbolo "BEGIN" cuando se esperaba uno de los siguientes: Pero en internet… Read More Error en begin al querer crear un package con procedimiento

November 24, 2022 MRLeave a comment

SET Command Appears to be Ignored in MySQL Procedure

Advertisements I finally got this function to work correctly until I tried to implement in a production state. When I run this procedure and call, I am only getting a value for the LowerLimit output and a NULL for the UpperLimit output. I added a SELECT in the procedure that shows the results for both… Read More SET Command Appears to be Ignored in MySQL Procedure

June 14, 2022 MRLeave a comment

How to handle "The given header was not found" when paging records in c# API GET request?

Advertisements I’m requesting data from an API that requires paging records based on a custom header called "cursor". Only 100 records may be retrieved per call and as such I’ve created a while loop to execute. The loop functions… until it doesn’t. Once all records are paged, the headers get dropped and my program errors… Read More How to handle "The given header was not found" when paging records in c# API GET request?

May 26, 2022 MRLeave a comment

How to execute a piece of code for each element of the result of a dynamic query in PostgreSQL?

Advertisements I have a dynamic query in my PostgreSQL function: execute format(‘select something from %’, table_name) I want to run some code for every record returned by the above statement. How can I do this? My first idea is as follows. I need to do something like this: execute format(‘select something from %’, table_name) into… Read More How to execute a piece of code for each element of the result of a dynamic query in PostgreSQL?

May 24, 2022 MRLeave a comment

Select count(*) IN ORACLE

Advertisements I’m trying to execute the below code to update tables but cannot get the count(*) result in CNT variable. How can i get the number of record in the tables before my update please ? The error i get executing the below code : Error report – ORA-06502: PL/SQL: numeric or value error: character… Read More Select count(*) IN ORACLE

May 19, 2022 MRLeave a comment

Having Challenges with Node.js Update SQL for Arithemetics

Advertisements When I do this update fasta_users set balance = balance + 7000 where id =1; it works fine, No challenge, but when i want to work on it programmatically, it tells me amount has to be a column, i do not understand why it behaves so. My code looks thus : app.put(‘/api/v1/user/fundWallet’,async function(req,res,next){ try… Read More Having Challenges with Node.js Update SQL for Arithemetics

May 18, 2022 MRLeave a comment

Transaction in C# On Procedure

Advertisements How to use Transaction in C# Code On Procedure? >Solution : You can do something like this using ADO .NET: SqlConnection con = new SqlConnection("YOURConnection"); SqlCommand command = new SqlCommand("your procedure",con); con.Open(); // this is a class you can use in order to manage transaction in C# for MS SQL // start scope SqlTransaction… Read More Transaction in C# On Procedure

May 17, 2022 MRLeave a comment

Dev solutions

Solutions for development problems

Tag: procedure