Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle APEX and Paypal IPN scripts?

24518Sep 8 2008 — edited Sep 9 2008
Has anyone used Paypal Web Payments Standard with an Instant Payment Notification script for Oracle APEX? Paypal site seems to give PHP and .NET examples only?

Thanks

Comments

John Edward Scott Sep 8 2008
Hello,

Have you looked at the Paypal/Apex whitepaper? -

http://www.oracle.com/technology/products/database/application_express/pdf/Integrating_Application_Express_with_PayPal_Payments_Pro.pdf

John.
--------------------------------------------
http://jes.blogs.shellprompt.net
http://www.apex-evangelists.com
24518 Sep 9 2008 — edited on Sep 9 2008
Yes I have had the document for quite a while. For Pro you need to set up SSL on your server and need a merchant account (Pro you did need to pay a monthly charge for though this seems to have been removed recently and not sure if you have to pay for a merchant account with them). Standard you dont need either as far as I understand but provides the functionality to pay by cards directly or by Paypal if you have an account with them. Future charges for Pro may return so why have it if Standard will do what you need and take less set up as security is taken care of as payments are made on the Paypal site rather than your own. There doesnt seem to be an example of using an IPN script with APEX though which Standard would require.

Edited by: shergar on Sep 9, 2008 6:21 AM
24518 Sep 9 2008
It would appear you cant use Paypal Web Payments Standard with APEX wheras you can use PHP and .NET and so are forced to pay the extra costs of Pro if you use APEX?
Andrew R Sep 9 2008
Hi,

"It would appear you cant use Paypal Web Payments Standard with APEX"

I have managed to implement Paypal standard using the Buy Now button method. I use PayPal to handle just the payment part of the ordering process, the rest of the process is handled by my application. For examples, visit:

http://www.genghisvinyl.co.uk
http://www.apexskins.com

Andrew.
24518 Sep 9 2008
Thanks for the reply Andrew.

I just checked it out and it does not seem to give an instant payment notification back to your site (which I need) which Web Payments Standard does .. however you need an IPN script for APEX for this Standard functionality?

Dont want to use Pro unless I have to .. it is £20/month (they have waived this until next Jan 09 so the takeup cant be too good from customers) and the inconvenience of having the responsibility of security on your site just so you can process payments on your own site. No upside for me as my payment page doesnt need to be exactly like the rest of my app, only downsides I can see in using Pro ... but why no IPN script for Standard using APEX?

It appears nobody has knowledge of this I thought someone might have used APEX and notification scripts before?
24518 Sep 9 2008
Found this script generator. Has anyone knowledge of using the Java / JSP generated script with APEX? Thanks.

https://www.paypaltech.com/SG2/

Info on IPN:

https://www.paypal.com/IntegrationCenter/ic_ipn.html
Andrew R Sep 9 2008
Can I ask why you need to use IPN? Are you expecting payments to be made outside of your application, ie asyncronously?
24518 Sep 9 2008
Andrew ... I need my app to get notification of successful payment in order that the customer can have options enabled to them on my site immediately (or not if payment failed). The site doesnt sell objects but enables services to them.
Andrew R Sep 9 2008
So the process has to be:

1. Customer makes payment via Paypal
2. IPN sent by Paypal
3. You process the IPN and 'enable' services for the customer

Is that correct?

If that correct then perhaps the PAYPAL_CONTROLLER procedure in the following thread can assist you in processing the IPN

382575

Hope this helps,

Andrew
---------------------------------------
http://www.apexskins.com
24518 Sep 9 2008
Thanks very much Andrew .. you are correct that is what my site does .. it enables specific database records to customers in reports according to what they have paid for.

I will take a look

Thanks
1 - 10
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 7 2008
Added on Sep 8 2008
10 comments
975 views