# \#sql-stored-procedure **URL:** https://forum.uipath.com/tag/sql-stored-procedure/1746.md [Latest](https://forum.uipath.com/latest.md) · [Categories](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md) --- ## [My stored procedure sql is working in attended but not working in unattended or remote debugging unattended](https://forum.uipath.com/t/my-stored-procedure-sql-is-working-in-attended-but-not-working-in-unattended-or-remote-debugging-unattended/5703682)
**Author:** [@Sathish\_Kumar5](https://forum.uipath.com/u/Sathish_Kumar5)\ **Replies:** 4\ **Last updated:** [December 27, 2025, 7:04am UTC](https://forum.uipath.com/t/my-stored-procedure-sql-is-working-in-attended-but-not-working-in-unattended-or-remote-debugging-unattended/5703682 "2025-12-27T07:04:20Z")
My stored procedure sql is working in attended but not working in unattended or remote debugging unattended, so how to fix this, any suggestions please --- ## [How to run packages in sql database](https://forum.uipath.com/t/how-to-run-packages-in-sql-database/5465496)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 2\ **Last updated:** [September 29, 2025, 4:31am UTC](https://forum.uipath.com/t/how-to-run-packages-in-sql-database/5465496 "2025-09-29T04:31:31Z")
Hello, my requirement is need to run packages in sql. for now once we trigger the package we are getting mail in outlook. how can we do this using UiPath , after conencting to database? help me to resolve this --- ## [What is the logic in document understanding workflow to extract details from different documents like HealthCard, PR, Driving License, Bills etc in KYC onboarding process automation?](https://forum.uipath.com/t/what-is-the-logic-in-document-understanding-workflow-to-extract-details-from-different-documents-like-healthcard-pr-driving-license-bills-etc-in-kyc-onboarding-process-automation/3447850)
**Author:** [@Vaishnav\_Tej](https://forum.uipath.com/u/Vaishnav_Tej)\ **Replies:** 6\ **Last updated:** [August 8, 2025, 6:42am UTC](https://forum.uipath.com/t/what-is-the-logic-in-document-understanding-workflow-to-extract-details-from-different-documents-like-healthcard-pr-driving-license-bills-etc-in-kyc-onboarding-process-automation/3447850 "2025-08-08T06:42:00Z")
Hi Everyone, I’m practicing KYC onboarding process automation using UiPath Studio. But I’m stuck with the logic. Goal is to automate: Email reading & classification Document extraction & validation(Document Unde… --- ## [Procedure or function '\' expects parameter '@\', which was not supplied.. While exporting variables to MSQL store procedure](https://forum.uipath.com/t/procedure-or-function-proc-name-expects-parameter-value-which-was-not-supplied-while-exporting-variables-to-msql-store-procedure/739713)
**Author:** [@aryan.guru](https://forum.uipath.com/u/aryan.guru)\ **Replies:** 4\ **Last updated:** [May 30, 2024, 4:27pm UTC](https://forum.uipath.com/t/procedure-or-function-proc-name-expects-parameter-value-which-was-not-supplied-while-exporting-variables-to-msql-store-procedure/739713 "2024-05-30T16:27:58Z")
I have a store procedure in SQL in which I have an insert query in which I’m inserting several values as log of the transaction happened in UiPath flow, after configuring the “Executing Non Query” Activity I am getting t… --- ## [Convert PQL Queries into Signal Queries](https://forum.uipath.com/t/convert-pql-queries-into-signal-queries/739639)
**Author:** [@AakashVaithiyanthan](https://forum.uipath.com/u/AakashVaithiyanthan)\ **Replies:** 0\ **Last updated:** [May 8, 2024, 10:25am UTC](https://forum.uipath.com/t/convert-pql-queries-into-signal-queries/739639 "2024-05-08T10:25:46Z")
Hello everyone, I’ve been facing some challenges with converting PQL queries into Signal queries because of their dynamic nature. Unlike static queries, PQL queries present complexities in conversion due to their dynami… --- ## [Having Trouble with Store procedure and cursor object](https://forum.uipath.com/t/having-trouble-with-store-procedure-and-cursor-object/611495)
**Author:** [@shirH](https://forum.uipath.com/u/shirH)\ **Replies:** 1\ **Last updated:** [March 16, 2024, 9:41am UTC](https://forum.uipath.com/t/having-trouble-with-store-procedure-and-cursor-object/611495 "2024-03-16T09:41:55Z")
Hi, I’m trying to call a store procedure in UiPath. the connection to the DB is working - because I tried to run a simple query and it worked. I have a store procedure that received few params, and also has CURSOR par… --- ## [Error While inserting data in stored procedure](https://forum.uipath.com/t/error-while-inserting-data-in-stored-procedure/718151)
**Author:** [@Binod\_Kumar\_Biswal](https://forum.uipath.com/u/Binod_Kumar_Biswal)\ **Replies:** 6\ **Last updated:** [February 8, 2024, 8:31am UTC](https://forum.uipath.com/t/error-while-inserting-data-in-stored-procedure/718151 "2024-02-08T08:31:08Z")
Hi Everyone, I am getting the below error while inserting data through Non Execute Query through procedure and I have also given parameters for insertion. Do let me know what changes I need to do to resolve the issue. … --- ## [Insert Data into Stored Procedure](https://forum.uipath.com/t/insert-data-into-stored-procedure/717814)
**Author:** [@Binod\_Kumar\_Biswal](https://forum.uipath.com/u/Binod_Kumar_Biswal)\ **Replies:** 5\ **Last updated:** [February 7, 2024, 12:24pm UTC](https://forum.uipath.com/t/insert-data-into-stored-procedure/717814 "2024-02-07T12:24:06Z")
Hello Everyone, How can we insert data into a table with the help of stored procedure and as I can’t use directly insertion sql query to insert values into the table. Do let me know to insert data into table with the h… --- ## [Issue in Calling Stored procedure from Execute Query activity](https://forum.uipath.com/t/issue-in-calling-stored-procedure-from-execute-query-activity/330380)
**Author:** [@MLT](https://forum.uipath.com/u/MLT)\ **Replies:** 14\ **Last updated:** [January 26, 2024, 10:54am UTC](https://forum.uipath.com/t/issue-in-calling-stored-procedure-from-execute-query-activity/330380 "2024-01-26T10:54:38Z")
Hi, I’m connecting and working with HSQLDB with UiPath everything works fine connection made and can call function and tables from UiPath but Currently im facing issue while calling procedure from UiPath but the same pr… --- ## [Execute Stored Procedures and Get the Output parameter using UiPath](https://forum.uipath.com/t/execute-stored-procedures-and-get-the-output-parameter-using-uipath/330925)
**Author:** [@dilii](https://forum.uipath.com/u/dilii)\ **Replies:** 8\ **Last updated:** [January 9, 2024, 9:11pm UTC](https://forum.uipath.com/t/execute-stored-procedures-and-get-the-output-parameter-using-uipath/330925 "2024-01-09T21:11:46Z")
How to execute Oracle Stored Procedures and get the output using UiPath? --- ## [How can I pass an always encrypted SQL parameter using Uipath Database activities](https://forum.uipath.com/t/how-can-i-pass-an-always-encrypted-sql-parameter-using-uipath-database-activities/549326)
**Author:** [@octavioelliot](https://forum.uipath.com/u/octavioelliot)\ **Replies:** 0\ **Last updated:** [May 29, 2023, 5:55pm UTC](https://forum.uipath.com/t/how-can-i-pass-an-always-encrypted-sql-parameter-using-uipath-database-activities/549326 "2023-05-29T17:55:01Z")
Hello, I have a procedure with an always encrypted column in a SQL db. As this procedure uses an encrypted ID as an argument, How do I do it to send this parameter using UiPath db activities? Some attempts I tried: … --- ## [SystemDB.Null returned by Stored Procedure but values are there](https://forum.uipath.com/t/systemdb-null-returned-by-stored-procedure-but-values-are-there/523843)
**Author:** [@SnehajitDas](https://forum.uipath.com/u/SnehajitDas)\ **Replies:** 4\ **Last updated:** [March 8, 2023, 1:10pm UTC](https://forum.uipath.com/t/systemdb-null-returned-by-stored-procedure-but-values-are-there/523843 "2023-03-08T13:10:40Z")
I am running few stored procedures given by business team which has 2 input field and 2 output fields (1. RetCode, 2.ErrMessage). In case of successful runs Retcode=0 and ErrMessage= “No Error” when run through SQL Serv… --- ## [How to handle in UiPath Studio if there is any issue in Stored Procedure?](https://forum.uipath.com/t/how-to-handle-in-uipath-studio-if-there-is-any-issue-in-stored-procedure/519281)
**Author:** [@Vaishnav\_Tej](https://forum.uipath.com/u/Vaishnav_Tej)\ **Replies:** 3\ **Last updated:** [February 21, 2023, 2:03pm UTC](https://forum.uipath.com/t/how-to-handle-in-uipath-studio-if-there-is-any-issue-in-stored-procedure/519281 "2023-02-21T14:03:42Z")
Hi All, I would like to know how to handle errors that occur in Stored Procedures which is connected to UiPath Studio using Database activities. Any Help would be appreciated :slight\_smile: Thanks in Advance. --- ## [Tutorial: Call UiPath Orchestrator API from SQL Server](https://forum.uipath.com/t/tutorial-call-uipath-orchestrator-api-from-sql-server/342864)
**Author:** [@KanadMehta](https://forum.uipath.com/u/KanadMehta)\ **Replies:** 3\ **Last updated:** [October 27, 2022, 4:14pm UTC](https://forum.uipath.com/t/tutorial-call-uipath-orchestrator-api-from-sql-server/342864 "2022-10-27T16:14:27Z")
Did you ever require to add a queue item directly from SQL? Did you ever think the Dispatcher process can be replaced entirely by SQL Trigger? Did you ever wish for a way to synchronize Asset values with SQL data? To a… --- ## [How to pass datatable as a parameter in sql Store procedure](https://forum.uipath.com/t/how-to-pass-datatable-as-a-parameter-in-sql-store-procedure/447803)
**Author:** [@neerajmca5](https://forum.uipath.com/u/neerajmca5)\ **Replies:** 1\ **Last updated:** [June 13, 2022, 5:21pm UTC](https://forum.uipath.com/t/how-to-pass-datatable-as-a-parameter-in-sql-store-procedure/447803 "2022-06-13T17:21:57Z")
Hi All, I have excel data into datatable now i want to pass datatable to the sql store procedure as a parameter . Please help me . Thanks in advance. --- ## [Using Variables in a SQL Query - String Commands must end in Double Quotes](https://forum.uipath.com/t/using-variables-in-a-sql-query-string-commands-must-end-in-double-quotes/414667)
**Author:** [@taxguy33](https://forum.uipath.com/u/taxguy33)\ **Replies:** 10\ **Last updated:** [April 14, 2022, 6:30am UTC](https://forum.uipath.com/t/using-variables-in-a-sql-query-string-commands-must-end-in-double-quotes/414667 "2022-04-14T06:30:14Z")
Hello, I recently was able to connect to our Database to start performing some SQL queries with UiPath Studio. However - I have only ever been able to complete the query by inserting the criteria in single quotes within… --- ## [SQL Stored procedure Passing Parameters To fetch particular records](https://forum.uipath.com/t/sql-stored-procedure-passing-parameters-to-fetch-particular-records/324558)
**Author:** [@pari\_patel](https://forum.uipath.com/u/pari_patel)\ **Replies:** 4\ **Last updated:** [June 29, 2021, 9:03pm UTC](https://forum.uipath.com/t/sql-stored-procedure-passing-parameters-to-fetch-particular-records/324558 "2021-06-29T21:03:53Z")
How Should I fetch particular records from Stored Procedure? I am having difficulty to pass parameters. In my Stored Procedure there are 3 invoice account number having sales order list. I want to fetch separate recor… --- ## [Fetch data from sql using stored procedure and pit into website](https://forum.uipath.com/t/fetch-data-from-sql-using-stored-procedure-and-pit-into-website/322140)
**Author:** [@pari\_patel](https://forum.uipath.com/u/pari_patel)\ **Replies:** 5\ **Last updated:** [June 13, 2021, 1:49am UTC](https://forum.uipath.com/t/fetch-data-from-sql-using-stored-procedure-and-pit-into-website/322140 "2021-06-13T01:49:37Z")
Can anyone help me to fetch Tracking information for sales order on website.. Need to fetch tracking number from data warehouse using sql stored procedure and put into particular order’s detail on website.