Skip to Content

Update table via HANA Procedure

Hi,

I am trying to update a table using a procedure and I tried this from both SQL console and also by creating the procedure from Project explorer option.

I see this message "feature not supported: INSERT/UPDATE/DELETE are not supported in the READ ONLY procedure/function", is there a way to create procedure with update functionality too?

Would any of you guide me if this is a access related message or the update feature is not supported via procedures?

Thanks,

Anil

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Sep 10, 2013 at 02:32 PM

    You also need to enable the ability to create read/write procedures in your HANA system. From the administration console, click on the configuration tab, then expand indexserver.ini then expand repository. Change the value for "sqlscript_mode" to UNSECURE

    Cheers,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2013 at 05:43 AM

    Hi Anil,

    As explained in here by Ravindra

    please try to repalce

    LANGUAGE SQLSCRIPT READS SQL DATA

    with

    LANGUAGE SQLSCRIPT

    i.e. by removing "READS SQL DATA"

    Regards

    Angad

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 16, 2013 at 05:04 PM

    Hi all,

    Thanks for all your responses. Summing it up I did the following to make my procedure allow DML statements and be able to debug.

    1. Per SAP note your procedure must be active in order to debug which means you (at least I ) cannot debug repository procedures create from SQL console, correct me if I am wrong.

    You have activated your procedures and they must belong to a project on your local workstation.

    2. I have granted the privileges to my user id (though it is SYSTEM in my case) to do debug and execute DML statements too.

    3. Create the tables in schema in schema other than "SYSTEM" and execute them to make sure the user name and schema name aren't the same.

    Finally got it going.. thanks every one again for your time/effort...Feel free to add your inputs if any!

    Thanks,

    Anil


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.