Problem:
When trying to upload a file on an AWS RDS instance to an S3 bucket I was getting this error:
SELECT rdsadmin.rdsadmin_s3_tasks.upload_to_s3(
p_bucket_name => 'db-bucket',
p_directory_name => 'DATA_PUMP_DIR',
p_prefix => 'EXPORT_SCHEMAS.dmp')
AS TASK_ID FROM DUAL;
ORA-06553: PLS-306: wrong number or types of arguments in call to 'UPLOAD_TO_S3'
06553. 00000 - "PLS-%s: %s"
*Cause:
*Action:
Error at Line: 2 Column: 7
Solution:
Add the following mandatory argument for subdirectory "even if it's empty" to the above command:
p_s3_prefix => '',
Final command will be:
SELECT rdsadmin.rdsadmin_s3_tasks.upload_to_s3(
p_bucket_name => 'db-bucket',
p_directory_name => 'DATA_PUMP_DIR',
p_s3_prefix => '',
p_prefix => 'EXPORT_SCHEMAS.dmp')
AS TASK_ID FROM DUAL;
Reference:
No comments:
Post a Comment