Skip to Content

INSERT statement in HDB procedure

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 06, 2015 at 12:18 PM

    Hi Shyam,

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

    Regards,

    ThamizharasaN.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 06, 2015 at 12:20 PM

    Hi Shyam,

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

    Thanks

    Kala

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2015 at 12:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded