• hi all,
    i have created the SP, mention in this topic.

    when i execute the sp : EXEC GECODE_U
    @Address = '1234 N. Main Street',
    @City = 'Santa Ana',
    @State = 'CA'
    I got the out put like below
    lat              | long                    | add                             | city      |state
    33.755324  |-117.867594     |1234 North Main Street    |Santa Ana  |    CA

    Here I given input address : 1234 N. Main Street after execution sp i got address :1234 North Main Street
    I want retrive exactely given input address is : 1234 N. Main Street only using this sp and without using cursor conecpt.
    can you please tell me how to achieve this case.