Home » SQL & PL/SQL » SQL & PL/SQL » Creating Procedure (2 merged) (Windows 10, Oracle Express Edition 10g, Developer 10g)
Creating Procedure (2 merged) [message #683040] Sun, 29 November 2020 03:05 Go to next message
shahzaib_4vip@hotmail.com
Messages: 401
Registered: December 2008
Location: karachi
Senior Member
Dear All,

Good Day!

My table is
Sale_Date , Chassis_number , Customer_name , Sale_price, Initial_advace, Rcd_from_customer

I create a report which show's detail balance of customer coming like

05-11-2020 , AZE15400120060 , CS Motors , 5000 , 500 , 3000 , Balance = 1500
05-11-2020 , AZE15400162060 , CS Motors , 7000 , 1000 , 3000 , Balance = 3000
05-11-2020 , AZE15400182060 , CS Motors , 6000 , 1000 , 5000 , Balance = 0

My report is working fine

Now I want Customer Limit if balance amount increased from 4000 then Entry permit will not allowed so I need to create some procedure which will call in form when I click on submit button to entry a new record.

Sorry for my bad English



Re: Creating Procedure (2 merged) [message #683042 is a reply to message #683040] Sun, 29 November 2020 04:21 Go to previous message
Michel Cadot
Messages: 67648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.
Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Previous Topic: Table joining with two columns sharing a foreign key
Next Topic: How to convert JSON into XML in Oracle 10g
Goto Forum:
  


Current Time: Fri Jan 22 11:09:19 CST 2021