cancel
Showing results for 
Search instead for 
Did you mean: 

INSERT statement in HDB procedure

shyam_uthaman
Participant
0 Kudos

Hi All,

I wrote an HDB procedure containing an insert statement.

Even after taking out the READS SQL DATA statement, it throws an error.

The package based procedures seem to work well.

Any thoughts on why HDB procedures have this problem?

Please let me know.

Thanks,

Shyam

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member194780
Active Participant
0 Kudos

Hi Shyam,

U mean to say the design time objects(created from Project Explorer) are working fine and the ones created from system directly throws an error while executing?

Provide the procedure snippet for more info

-Avinash

0 Kudos

Hi Shyam,

Did you set the default schema name? plz check once.

Thanks

Kala

thamizharasan
Explorer
0 Kudos

Hi Shyam,

What is the error it's throwing. Can you share the procedure..?

Regards,

ThamizharasaN.