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
• 5,380 points
• 1,415 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
• 13,969 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
• 2,149 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,460 points
• 21,959 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
• 5,380 points
• 1,553 views
0 votes
1 answer

How do I verify the kernel parameters to check for the pre-requisities of Oracle 11 + versions?

Please check the below-mentioned syntax and commands: To ...READ MORE

answered Oct 5, 2018 in Linux Administration by Frankie
• 9,830 points
• 17,531 views