Convert oracle UDF function with to number and value error expection in it to AWS RDS maria db

0 votes
create or replace FUNCTION num_check (p_string IN VARCHAR2) RETURN NUMBER IS v_new_num NUMBER; BEGIN v_new_num := TO_NUMBER(p_string); RETURN v_new_num; EXCEPTION WHEN VALUE_ERROR THEN RETURN NULL; END num_check;
Dec 14, 2022 in AWS by Tejashwini
• 3,820 points
212 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In AWS

0 votes
3 answers

How to check instance state and status via Lambda function in AWS?

import boto3 from pprint import pprint def lambda_handler(event, context):          # ...READ MORE

answered Sep 8, 2020 in AWS by Shrikant
• 180 points
9,671 views
0 votes
1 answer

How to monitor Oracle RDS instance in AWS?

You could probably use Cloudwatch itself for ...READ MORE

answered Nov 2, 2020 in AWS by Nilesh
515 views
0 votes
1 answer

Unziiping a tar.gz file in aws s3 bucket and upload it back to s3 using lambda

Hi@khyati, You can do your task using lambda. ...READ MORE

answered Dec 3, 2020 in AWS by MD
• 95,440 points
17,897 views
0 votes
0 answers

How to use "alter system.." sql statement in AWS RDS oracle?

"ALTER SYSTEM FLUSH BUFFER_CACHE;" Oracle's data buffer ...READ MORE

Dec 14, 2022 in AWS by Tejashwini
• 3,820 points
241 views
0 votes
1 answer
0 votes
0 answers

How do I list all the columns in a table?

For the various popular database systems, how ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
• 38,010 points
329 views
0 votes
1 answer

Want a command to be executed in Salt only if a directory is empty

You should consider using this inside your ...READ MORE

answered Jun 12, 2018 in DevOps Tools by Damon Salvatore
• 5,980 points
1,481 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP