Re: ec2 webservices with plsql

From: Vamshi Damidi <dbaprimatics_at_gmail.com>
Date: Tue, 2 Oct 2012 20:59:38 -0400
Message-ID: <CAKshVhwVrhPQX3EF0qbewDm5MN3Pj6Fz6jLzfC1mrBegXn2c8w_at_mail.gmail.com>

Below is code i used to do this.
declare
l_token varchar2(4000);
l_date_string varchar2(100):= get_date_string; url varchar2(2000) ;
begin
l_token := amazon_signature('GET'||chr(10)||'ec2.amazonaws.com'||chr(10)||'/'||chr(10)||'AWSAccessKeyId='||AWSACCESSKEY||'&Timestamp='||wwv_flow_utilities.url_encode2( l_date_string)||'&Action=DescribeRegions&Version=2009-08-15&SignatureVersion=1', AWSSECRETKEY);
l_token := wwv_flow_utilities.url_encode2 ( l_token ); dbms_output.put_line(l_token);
url := '
https://ec2.amazonaws.com/?SignatureVersion=1&Action=DescribeRegions&Version=2009-08-15&Timestamp='||wwv_flow_utilities.url_encode2(l_date_string)||'&AWSAccessKeyId='||AWSACCESSKEY||'&Signature='||l_token ;
dbms_output.put_line ( url );
end;
/

i keep getting error message that my signature is not valid.

Thanks,
Vamshi .D

On Tue, Oct 2, 2012 at 8:19 PM, Vamshi Damidi <dbaprimatics_at_gmail.com>wrote:

> Hi All -- Hope everyone is doing great.
> I am trying to write ec2 webservices with plsql
> based on below links.
> http://code.google.com/p/plsql-utils/
> http://ora-00001.blogspot.com/2011/03/amazon-s3-api-for-plsql.html
> http://jastraub.blogspot.com/2009_07_01_archive.html
>
> i tried to write code for EC2 request to describeregions and i am always
> having problems with signature.
>
> Can some one suggest any code for this activity.
> i dont have my code handy while writing this email so going to post code
> in my next reply.
>
> Any help would be greatly appreciate.
>
> Thanks,
> Vamshi .D
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 03 2012 - 02:59:38 CEST