How to fix error received while inserting into table through report builder into oracle database

Question

How to fix error received while inserting into table through report builder into oracle database

Madani, Ramya Krishna 0

I am trying to insert records through report builder into oracle database and it is showing dataset related error

Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-02-18T06:30:57.6366667+00:00

Hi Madani, Ramya Krishna,

Thanks for reaching out to the SQL Q&A forum. Could you please share more details about the error? This will help us better understand the issue and provide an appropriate solution

Thanks,

Lakshmi.
Madani, Ramya Krishna 0 Reputation points

2026-02-18T07:39:50.3+00:00

Below is the error we receiving when trying to run report. we are running stored procedure to insert record in to a table

ORA-01008: not all variables bound ---------------------------- Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand) ---------------------------- An error has occurred during report processing. (rsProcessingAborted)
Madani, Ramya Krishna 0 Reputation points

2026-02-20T06:41:09.19+00:00

@Lakshmi Narayana Garikapati can you please help to provide suggestions on the erros

2 answers

Your answer

Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-02-18T06:30:57.6366667+00:00

Hi Madani, Ramya Krishna,

Thanks for reaching out to the SQL Q&A forum. Could you please share more details about the error? This will help us better understand the issue and provide an appropriate solution

Thanks,

Lakshmi.
Madani, Ramya Krishna 0 Reputation points

2026-02-18T07:39:50.3+00:00

Below is the error we receiving when trying to run report. we are running stored procedure to insert record in to a table

ORA-01008: not all variables bound ---------------------------- Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand) ---------------------------- An error has occurred during report processing. (rsProcessingAborted)
Madani, Ramya Krishna 0 Reputation points

2026-02-20T06:41:09.19+00:00

@Lakshmi Narayana Garikapati can you please help to provide suggestions on the erros

Answer 1

Lakshmi Narayana Garikapati 1,225 Microsoft External Staff Moderator

Hi Madani, Ramya Krishna

The error ORA-01008: not all variables bound usually means that one or more parameters expected by your stored procedure aren’t being passed correctly from Report Builder. A few things to check:

Stored procedure signature: Verify how many parameters your procedure requires and their types.

Dataset query: In Report Builder, the call should look like:

BEGIN InsertRecord(:p_id, :p_name); END;

Every parameter must be prefixed with a colon and match the procedure definition.

Report parameters: Make sure you’ve defined report parameters for each procedure parameter and mapped them to the dataset.

Data types: Ensure the parameter types in Report Builder align with what Oracle expects (e.g., NUMBER vs VARCHAR2).

Test outside Report Builder: Run the same PL/SQL block in SQL Developer with bind variables to confirm it works before wiring it into the report.

Thanks,

Lakshmi

Madani, Ramya Krishna 0 Reputation points

2026-02-26T12:18:13.9466667+00:00

Hi @Lakshmi narayana Garlapati

we have verified all the options provided above and still we are getting same error, also we checked PL/SQL block in SQL developer it is running successfully, and records are inserted into table.

And we are not able to run the same procedure from rdl file. we have a question regarding inserting through report builder as SSRS is meant mainly for reporting do we need any additional license or plugins kind of things to run Insert query as we can see only viewreport button in the web portal.

I have added attachment from our application for your references.

Thanks in Advance for your response and support.

Regards

Ramya Krishna Madaniimage (1).png
Lakshmi Narayana Garikapati 1,225 Reputation points Microsoft External Staff Moderator

2026-03-03T10:50:58.9833333+00:00

Hi Madani, Ramya Krishna,

Thank you for reaching out to the SQL Forum.

To help resolve this further, I recommend raising a support ticket so our support team can assist you directly. Please refer to the following link for instructions on how to create a support ticket:

https://support.serviceshub.microsoft.com/supportforbusiness/create

We appreciate your engagement and thank you for being an active part of the community.

Thanks,

Lakshmi.

Answer 2

Madani, Ramya Krishna 0

Hi @Lakshmi Narayana Garikapati

can you please help to suggest on the issue.

Thanks

Ramya Krishna Madani

0 comments

Share via

How to fix error received while inserting into table through report builder into oracle database

2 answers

Your answer