473,550 Members | 2,761 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

isql-webforms

7 New Member
Does any one know, how to call a stored procedure that accepts 3 arguments from a webform.

ex: create or replace PROCEDURE insertproject(j num J.J#%type, jname J.JNAME%type, city J.CITY%type) IS .........

I think the following form action is the key. Any other advice is most welcome.

From a web form.
Expand|Select|Wrap|Line Numbers
  1. <form action="http://hostname:port/isqlplus/dynamic?script=http://hostname:port/~user/insertproject.sql" method="get">
  2.                <p>
  3.                  <h3> Enter Project's J#: </h3>
  4.                     <input type="text" name="jnum" size="35" />
  5.                </p>
  6.                <p>
  7.                  <h3> Enter Project's Name: </h3>
  8.                     <input type="text" name="jname" size="35" />
  9.                </p>
  10.                <p>
  11.                  <h3> Enter Project's City: </h3>
  12.                     <input type="text" name="city" size="35" />
  13.                </p>
  14.                <p>
  15.                  <input type="submit" value="Submit Insert" />
  16.                </p>
  17.           </form>
  18.  
Thank you.
Anjana

If I have violated any rules, it's not intentional. Help will be appreciated than a 2nd warning with second posting ever.
Feb 15 '08 #1
5 1251
debasisdas
8,127 Recognized Expert Expert
What that code is for ?

Is that Oracle code ?
Feb 15 '08 #2
patilanjana
7 New Member
The code is web form.

Anjana
Feb 15 '08 #3
debasisdas
8,127 Recognized Expert Expert
The code is web form.

Anjana
Then why that is posted in oracle forum ?

Please post in related forum only.
Feb 15 '08 #4
amitpatel66
2,367 Recognized Expert Top Contributor
Thread moved to HTML forum
Feb 15 '08 #5
drhowarddrfine
7,435 Recognized Expert Expert
Well, SQL web forms don't belong in the HTML forum either but I don't know where to send it.
Feb 15 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
3717
by: Rui Cunha | last post by:
Hi, i'm having some problems at work with isql*plus in what concerns with session timeouts... here is the scenario: a class with 30/40 students working on PL/SQL and requesting the database server for info.no client installation was made...they only use the isqlplus tool via browser...
1
5138
by: Jacob Grydholt Jensen | last post by:
I am trying to learn iSQL*Plus for the 1Z0-007 exam. I am having a bit of problems with the substitution variables. My understanding was that they behave as in SQL*Plus, but my experiments beg to differ. I log on to the sample schema 'hr' and enter the following statements: -- statements begin set verify on define name = K%
6
14543
by: Alex Vilner | last post by:
Hello! We have a set of individual .SQL scripts which we would like to execute against a MS SQL Server 2000. Is there any way to have ISQL utility (or any other means) to execute all of them without having to establish a separate database connection for each script: isql -Ux -Py -Ss -i script1.sql isql -Ux -Py -Ss -i script2.sql isql...
5
23341
by: Jay Chan | last post by:
I am trying to use a command line program to run a stored procedure that generates output in a comma-delimitted format. Somehow, ISQL or OSQL always wrap the lines at 256 characters. I believe this has something to do with the column width switch (-w). But enlarging the column width to 800 characters max still doesn't help. The following is a...
1
24730
by: Gary | last post by:
I want to run and 'Alter Database' statement from within a batch file. The batch file is to be run from an external automation program, (don't ask why).. I know the syntax for the alter db statement but not sure how to do it in a batch file and also If I have 2 instances how do I run it against each instance. All being done on Windows 2000...
3
3598
by: anuu | last post by:
Hi, I have created a database as pubs.qa and wrote a command utility to query a table. isql -S server -E -d pubs.qa -i qry.sql -b -n contents of qry.sql
4
3815
by: Marcin Zmyslowski | last post by:
Hello everyone! I have the following problem. I`ve opened a Query Analyser and write the statement: -isql -S 'PL6XXXX' -i 'd:\SQL_Server_2000\Raport_WWW.sql' I got the following erorr message: Incorrect syntax near -S
3
8587
by: yanakal | last post by:
Hi, I'm using isql to query data and output the same to a flat file. The isql has the following command options ' -h-1 -w500 -n -b -s"" '. In the SQL_CODE, the first two lines before the select statement are use dbname set nocount on go When I run this, an additional blank line is put into the output file. Actually, there are two lines...
1
11254
by: Philip Bondi | last post by:
Hello to all SQL Server junkies who work with non-English characters: For people running scripts from the command line using ANSI files with special characters, it is very important to use isql and disable "Automatic ANSI to OEM conversion": - This only affects isql from the command line, and no gui applications -...
0
1598
by: rbarry | last post by:
I have a stored procedure that contains a statement like: select @myvar = count(*) from mytable where mycolumn is null when I run the procedure from query analyser a value is set in @myvar which is output to a table where I can see it. Without making any changes, when I run the identical procedure using isql to execute the procedure...
0
7561
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7999
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7520
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7845
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6101
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5403
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5129
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3532
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
801
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.