oracle - populate placeholders for a column with values dynamically -


I have the following table structure, which holds the error code and related error messages: 

  ERR_CODE ERR_MESSAGE CN001 Invalid user name: USERNM CN002 Invalid password: PWD

In my PLSQL code, I want to change values ​​dynamically for username and password.

I think that the replacement can be replaced by the clause but in that case the query should be stable.

I am looking for a taste to execute immediately in which it can: 

  select ERR_MESSAGE from ERROR_MESSAGES where ERR_CODE = ' CN001 '}' I_LL_RMS_USG is using;

Or maybe I can break it in 2 steps: 

  Select ERR_MESSAGE from ERROR_MESSAGES to err_msg_var where ERR_CODE = 'CN001'; Use l_err_msg in EXECUTE_IMMDIATE err_msg_var l_curr_user;

Actually, I'm trying to reduce the number of steps involved or maybe get a better performance query or approach.

Thanks in advance!

No, in this situation, there will be no help in the statement execute immediately . Apart from this, there is no need to actually use it - everything (selection list, table name) is known at compile time, it comes down only for string replacement, use static query, not dynamic replacement (or string formatting ) You have at least two options to do:

  1. Just replace () function: 

      Set server output; clear screen; Declared l_result varchar2 (50); Select err_message from error_messages in l_result where err_code = 'CN001'; Dbms_output.put_line (replace (l_result, ': USERNM', 'new value')); End;

    Result: 

      Invalid user name new value

  2. If possible, Update err_message of your error_message table by transferring : USERNM and : PWD and other similar sub-strings. The column placeholder denotes that with the % s (placeholder for one letter) or % d (placeholder for any integer, if you have one) and the package Use and special The format_message () function: 

      set Srhwarautput; clear screen; Declared l_result varchar2 (50); Select err_message from error_messages in l_result where err_code = 'CN001'; Dbms_output.put_line (utl_lms.format_message (l_result, 'new_value_goes_here')); End;

    Result: 

      invalid user name new_value_goes_here

Comments

Post a Comment

Popular posts from this blog

c# - Reactive Extensions ControlScheduler -

Well, I'm using Reactive Extension Event Handler to handle my app events, I run the headlines on the Yuri thread. I also use ControlSubular for However, recently I am getting cross thread exception despite using control scheduler and I do not know what the problem is. Code: Observable.FromEventPattern & Lt; String & gt; (CC, "UiAlertMessage", New Control Session ()) Subscribe (_ = & gt; {Alert Control. (Show this language, title, _.EventArgs.UppercaseFirst ());}); The new control scheduler (this) is not to run the code on the UI control thread, so I do not get cross threading exceptions? you should do Observable.FromEventPattern & lt; String & gt; (CC, "UiAlertMessage"). AboveOption (this). Subscribe (_ = & gt; {Alert Control. (Show this language, Titles, _.EventArgs.UppercaseFirst ());}); This is the standard way of sending a scheduler related to specific controls. Passing control scheduler as you have got subsc...
Read more

scala - Play Framework - how to bind form to a session field -

Is there any way, I can get some parameters from the header, cookies (log in userId in my case) , And then apply it in a form which I know who will deposit the ticket? SupportForm supportForm: form [supportTicket] = form (mapping ("question" -> text, "priority" -> text) (apply support ticket. (HelpText.update) What are the good practices here? What is the call to apply the request, when I can use it (and also a good practice?) Edit An issue, absolutely deceiving anyone if I were to create a hidden area with this value. It could Ript, but the issue may be re-used in any way to verify and return the form, it can not be sure how it ....
Read more

javascript - Enable/Disable form elements and changing the values of button at a time? -

requirement: text is a button with "disabled" when the page opens, then I want to disable it when the user clicks on button , I want to enable my form field and at the same time I want to change the value of my button to "enabled." I have an example of how the button's value, but how can I enable / disable it at the same time? & lt; H: form & gt; Please press this button & lt; H: command button id = "cb1" value = "# {ActionBean.buttonText}" instant = "true" functionalist = "# {ActionBean.processMyAction}" /> & Lt; / H: form & gt; My Bean class looks like this: / * action listener method * / public zeroes process my action (verb phenomenon) {disable =! Disable; System.out.println ("disable:" + disabled); If (buttonText.equals ("disable")) {buttonText = "enable"; System.out.println ("Button Type:" + Button); } Else {buttonText = "disable...
Read more