Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Pass a string value to a Procedure

User_GVHF4May 19 2023 — edited May 19 2023

The following SQL for Microsoft SQL Server

How do I do the same in PL/SQL?

USE AdventureWorks 
GO 

CREATE PROCEDURE dbo.uspGetAddress @City nvarchar(30) 
AS 
SELECT * 
FROM Person.Address 
WHERE City = @City 
GO
EXEC dbo.uspGetAddress @City = 'New York'
This post has been answered by Barbara Boehmer on May 19 2023
Jump to Answer
Comments
Post Details
Added on May 19 2023
4 comments
164 views